|
|
Auto Fill by
kbr
I have a set of names which are listed in a single row in different columns.
Like Column A has one name and then column B has other name and so on upto...
|
|
5 |
116 |
|
|
Force a filter beyond blank rows by
duketter
Excel 2007 - I am applying a filter to a table, however the filter entry
stops on when there is a blank row in the file (example, filter works from
rows...
|
January 19th, 2010 06:53 PM
by Eduardo
|
1 |
127 |
|
|
Countif with multiple criteria by
Allen
I've looked at the other posts with a similar subject but haven't found one
that really fits the criteria of my problem. I have a spreadsheet that, in
row 7...
|
January 19th, 2010 06:51 PM
by Allen
|
0 |
109 |
|
|
Transpose a table by
kbr
How do I transpose a table whose values are created by referencing on to a
different spreadsheet and not by typing.
example- A1 in sheet 2 refers to C3 in...
|
January 19th, 2010 06:30 PM
by kbr
|
2 |
122 |
|
|
Match by
Jim
Hello,
I would like to ask for help with a formula.
If I have data in two columns of one sheet; and on the second sheet I would
like to bring over only the...
|
|
3 |
107 |
|
|
Convert Date to MMYY format by
Doug Muegge
I would like to change the underlying date format from e.g. 01-May-09 to
May-09. I can change the format so that the displayed date is in correct
format but...
|
|
2 |
119 |
|
|
Restarte page numbering by
Lupe
Hi,
I've searched the questions but could not find exactly what I'm looking for.
I have a spreadsheet with different pagebreaks.
I would like to restart page...
|
January 19th, 2010 05:55 PM
by Lupe
|
0 |
119 |
|
|
Selecting more cells than I want by
ClaireView
I’ve got a strange one. I’m working in my spreadsheet, then suddenly when I
click on a cell, it captures the six or seven cells below it, in addition to...
|
January 19th, 2010 05:44 PM
by Mike H
|
6 |
107 |
|
|
|
January 19th, 2010 05:31 PM
by Rob2204
|
0 |
111 |
|
|
Recover autorecover! by
Tim Green
Just as I finished working on a document, Excel crashed. I have autorecover
set to 10-minute intervals. I checked the box to restart and recover
documents....
|
|
0 |
95 |
|
|
=IF(A2="","",TEXT(A2,"dddd")) by
Jim
Hello,
I'm currently using this formula to pull out the month, day and year from a
date.
The formula is pulling out the day of the week, but I also would...
|
|
3 |
125 |
|
|
Saving Excel 07 as .WK4 by
tms0926
Good morning,
I save Excel 03 spreadsheets as WK4 to import data into a lotus notes
database. Can Excel 07 spreadsheets be saved as WK4? Is there a file...
|
|
1 |
125 |
|
|
|
January 19th, 2010 05:12 PM
by Keri B
|
0 |
212 |
|
|
|
January 19th, 2010 05:05 PM
by Luke M
|
1 |
121 |
|
|
Language by
Ricku\y
How do I set the toolbar and all buttons to Japanese?
|
January 19th, 2010 05:04 PM
by Ricku\y
|
0 |
95 |
|
|
Comparing worksheets by
rudyeb
I get updates weekly from one of my customers that list all the parts
we make and when they are due for delivery. I would like to be able
to
download the file...
|
January 19th, 2010 04:51 PM
by Luke M
|
1 |
101 |
|
|
|
January 19th, 2010 04:07 PM
by Kim
|
4 |
108 |
|
|
recover data by
S n P
I have Office 2007. Is there an autosave option on this version. I just lost
an incredible amount of data and have to rekey. :-(
|
|
4 |
109 |
|
|
|
|
0 |
160 |
|
|
Referencing a cell by
Wombat
I have a cell in a worksheet = B1 of a different worksheet. What should I do
if I want this cell to ALWAYS show what is in B1 regardless of any new rows...
|
January 19th, 2010 03:49 PM
by Wombat
|
6 |
126 |