Excel 2003- Tabbing to a specific location in a cell
I have created a template and I want to be able to fill in parts of the
by just tabbing and the cursor to move to the next cell...and to a specific
area in the cell...how do i set up my template to do this?
THanks so much
unlock the cells you want to tab to. leave the other cells protected. then
protected the sheet.
"monty the magician" <monty the email@example.com> wrote in
>I have created a template and I want to be able to f...Mails Combined
I mistakenly delete all mails from Inbox and then found them on the deleted Items and selected all and ask to move folders back to Inbox.
the problem is all mails were combined into one email and moved back in to Inbox as a single email.
How do i go back to the original version. How do i uncombined all the mails in to individual mails from the right recipient? Please help ASAP..
Submitted using http://www.outlookforums.com
...how do i set up drop down menus to populate cells in excel?
I'm trying to build a database in excel, and to aide data inputting, i'm
trying to figure out if you can use drop down menu's like in the form view of
access. eg in access you list all the possble responses and add this to the
drop down menu for selection to populate the field so you don't have to type
it out again. I'm using excel because several people will need access to the
file and not many use access. Is it possible to do this in excel???
You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and here:
h...Merged Cell Character Limitation?
Is there a limitation to the number of characters that can
be entered into a merged cell? I have a document which
has a merged cell consisting of 12 rows and 9 coulmns (for
text entry). I set the cell to word wrap. However the
word wrapping ceases after roughly 1500 characters, and
the text is no longer visible to the user in the cell
(even though there appears to be room). If this is a
limitation, is there a known work around?
there's a maximum of 1024 characters per cell. Though you can increase
this by manually adding line breaks with ALT+ENTER
Fra...delete values in several cells without deleting the formulas
I wanted to clear the values in a spreadsheet without deleting the formulas
or formatting in the spreadsheet. For example: A budget sheet made for every
year, the formulas and formatting remains the same, only the values change.
I tried paste special formulas....in this case, if values are present, they
get copied too.
you can't delete the 'values' from a formula. The formula will always
calculate its result
"dranreb" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:43255A99-86BA-45A5-BB09-FCAEC002A09...How can I delete an infinite number of garbage cells to the right
I highlighted many entire rows with color. Now my excel wants to print 115
pages. I can define a narrow print area, but I really want to delete the
garbage color cells to the right. When I drag to the right, there seems to
be an infinite number of cells.
don't drag. place your curser in the first row and column that you want to
delete left. hold the shift key down with left hand and with right hand, hit
end then the down arrrow. hit the end key again then the left arrow. excel
will select all cells from row 1 to bottom and from curser position in row 1
to far left. ...Set Cell Padding on word tables with merged cells
Below macro sets certain padding values for the selected table.
Regrettably it fails to work on tables with merged cells. Have you got
any idea how to re-write the code so that tables featuring merged
cells also get worked on?
Help is much appreciated. Thank you very much in advance.
Dim myCell As Cell
Dim myRow As row
Dim myTable As Table
Set myTable = Selection.Tables(1)
For Each myRow In myTable.rows
For Each myCell In myRow.Cells
myCell.TopPadding = CentimetersToPoints(0)
myCell.BottomPadding = C...Copying data from another record
Being fairly new to Access, can anyone tell me please is it possible to
copy data, a field at a time from a previously displayed record.
The situation is that I have a lot of records to enter that contain data
that is either very similar to existing records or similar to each other.
My ancient DOS database used to allow the insertion into a new record of
data from the previously displayed record one field at a time by simply
pressing F4. Can Access do anything like this or can a Form be
programmed to do this?
Use Ctrl-' (single quote) to copy the value fro...Printing Entire Contents of Cell
A couple columns in a spreadsheet have lengthy text with the cell
formatting set to wrap. Not all of the text displays when viewing the
screen, but when clicking on the cell to edit, the contents are there.
The real probem is that when printing, the contents of some of these
cells are truncated. How do I get the entire contents to print?
waterdawg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26835
View this thread: http://www.excelforum.com/showthread.php?threadid=40084...Sorting and coloring cells, formula or macro help needed
I have a problem that i don't know how to solve. I wrote it all in my excel
file that needs to be done.
File is here http://www.sendspace.com/file/q4jc71
Anything that isn't clear, pls ask me. I need this really badly, because my
tables sometimes have thousands of those records.
> I have a problem that i don't know how to solve. I wrote it all in my excel
> file that needs to be done.
> File is here http://www.sendspace.com/fi...How can I copy a list from word into a single cell in excel
Data in word is presented as a bullet list. I have copied this data into a
new doc and removed the formatting to leave just the list of items. I now
wish to copy this data into excel but want it to appear in one single cell
retaining its list format rather than continuous text
Well, you can save it as TEXT and then read into WORD. If you really want
it in one cell, you can then concatenate the values together using a formula
similar to this
If you want a space between the data, use
Remember that there is a cell length limit that you may come...merge/combine workshhets
I need to merge about 75 worksheets into one spreadsheet on a regular basis -
all have exactly the same format/layout etc back can vary in the number of
Try this Jeff
Regards Ron de Bruin
"Jeff224" <Jeff224@discussions.microsoft.com> wrote in message news:C6790506-2888-4F4D-80EA-BB0D9F9B27A2@microsoft.com...
>I need to merge about 75 worksheets into one spreadsheet on a regular basis -
> all have exactly the same format/layout etc back can vary in the number of
http://www.rondebru...Documenting the backup of data
This may not be the place to ask however i am looking for resources on
how i may document data I am backing up from an oracle database to MS
Basically I have my oracle database and i have an Acess database.
I have to back up 3 tables from oracle into access.
I have no idea how i would document this.
I want to say Columns 1, column 2 from table A in oracle will be
backed up to Column 1a and Column 1b in Access.
Has anyone had similar exeperiences?
Does anyone know of any resources on the net or example?
...numbers in data sheet of stacked bar chart
I'm trying to label segments in a stacked bar chart, example: 1-10, 11-20,
etc. I'm not able to enter the number with the dash. In most cases it
automatically changes to Jan-10. Any tips on how I can fix this? Thanks!
Format the cell as text and see if that helps.
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
"Genevieve" <Genevieve@discussions.microsoft.com> wrote in me...Open Workbook to Specific Cell
I do not understand why Excel works this way, and would like help please to
understand it, and how I can work around it. I am using Excel 2003.
I have 2 workbooks. My test workbook (to understand how this is working)
has a macro behind a button that calls... Workbooks.Open
Filename:="E:\Address and Telephone Book.xls".
Now this works fine except that when the "Address and Telephone Book.xls" is
opened, the active cell happens to be the last active cell location from the
last time the "Address and Telephone Book.xls" was saved. This is very
an...cell displays formula
I sometimes run into this phenomena where I change a formula or type in
a new formula and suddenly Excel keeps displaying the formula instead of
This usually happens with a few cells only, i.e. the majority of the
cells just display regular results while only the few affected ones
display the formulas.
I am not in formula auditing mode, so I believe this is pretty much an
Excel bug. But what can I do about it?
pwermuth's Profile: http://www.excelforum.com/member.p...Use Pivot Table data in formula
I have a pivot table that changes based on the "Job
Number" value I choose in the PAGE section of the pivot
table. I have a formula elsewhere on the spreadsheet
that picks up the value from the "Amount" column of the
pivot table. Problem is that when I change the "Job
Number" in the pivot table the external formula gives me
the #REF! error because it is still looking for the data
from the previous job. Any way to change that external
formula to a relative formula so that it picks up the
current amount in the pivot table instead of erroring out
when I ...How to find multiple cells/replace whole cells w/data
I am trying to find a specific set of characters in multiple cells in a
column. Once found, I need to replace the data within found cells with a
specific text string. I have been able to replace a text string, but not the
Perform a search and replace, and add an asterisk before and after your
"search for" parameter. Replace with your desired cell contents.
Search for: *your text here*
Replace with: desired cell contents
Instead of 'Find', turn on data filters and select Custom... Use the
drop-downs to make the condition 'contains' and then ente...How to exclude cells from a datasource?
I have an XY chart in excel97 that uses a range of cells
for the data source.
Every now and then I would like to exclude a XYnode from
the chart. Without having to reselt the datasource.
Is there a value one can enter in the cell that exludes it
from the graph (compare: putting text in a cell excludes
it from the SUM() function).
point X Y
a 1 1
b 2 2
c 3 3
Gives a graph with two lines connecting the three points
point X Y
a 1 1
b ? ?
c 3 3
Should give a graph with one line connecting point a and c.
Point b is left out.
Or is the...Changing worksheet cells from inside a function
The following code in VB (excel 2000):
----------- start code
function f(x as double) as double
cells(1,1) = "A"
f = x + 2
----------- end code
produces #ARG error when inserted into a worksheet.
The offending line is:
cells(1,1) = "A"
Does it mean I can't change worksheet cells from inside
a function ? But macros do it.
What I'm doing wrong, or is there a way around ?
Antek, Warsaw, Poland
remove SPAM before onet.pl
A function, when used in a worksheet, cannot change or alter an...Incrementing Cell Numbers
I have created an excel "Workorder" form for our employees to write in what
machine they are working on, what parts they used, and how long they spent
on the repair...
The problem... I need to print out hundreds of these forms for the men to
use, and each copy of the form needs to have an unique number.
Is there a way to program a cell to automatically increment by 1 every time
it is printed? Again, I need to print hundreds at a time, and I need them
to automatically increment by 1.
Place this in ThisWorkbook module:
Private Sub Workbook_BeforePrint(Cancel ...Finding the combination that appears more times
i have a list on excel 2007 that displays the purchase of items on columns
A:E, each column showing one (1) item
I want to find what combination of items appears more times, especifically,
which combination of four (4) is the favorite mix
A B C D F
A C D E F
B C D E F
B C D F Z
in this example, the winner would be (B, C, D, E) as it appears 3 times
the main problem is that I have over 1,000 rows
and trying with =SUMPRODUCT(COUNTIF(A1:E1,$N$1:$R$1)) por each combination
would take forever...
is there a simpler, quicker ...Data Form Problem
I have a fairly simple table, with about 7 columns of data which I have
created for a co-worker. Most rows contain a single line of data,
but the last one of the fields uses "wrap text" and may have as many as
7-10 lines in that field. I am trying to make it so she can use the
Data Form method for data input. I am able to get the Form to be
created, but it says I only have one record . . . when very clearly
there are many more records. Does anyone know why this might be?
I thought it might be because of the "wrap text" in the one column . .
. and so I tried c...Date value in cell with text
I would like a cell in Excel 2000 to have some text plus today's date,
"Total orders as of 3/09"
I was able to pull the current date with =NOW()
and right clicking the cell and choosing the date to look like 3/09
I was thinking that my formula should look like
="Total orders as of "&NOW()
="Total orders as of "& TEXT(TODAY(),"m/dd")
Microsoft MVP - Excel
<email@example.com> wrote in message
>I...Reference a cell value in a formula
I have the following formula:
I want the "15000" to be replaced by the varaible value of a cell in an
other worksheet ("Summary").
I tried using INDIRECT but it didn't work.
Thanks in advance
C4 in this case is the cell that holds the number of items to be used in the
If the post is helpful, please consider donating something to an animal
charity on my behalf ..... and click Yes
> I have the f...