|
|
Certain worksheets won't print by
Larry_thornton
I have a workbook with 40+ sheets in it.
My challenge is that certain sheets won't print and others will. I have to
select all the cells on the sheet that...
|
|
1 |
98 |
|
|
How to use vlookup in an array formula by
Jill
In sheet1, I have rows and columns whose cells contain strings like "S", "M",
"L", and "XL". Some cells are empty. In sheet2, is a column A of the same...
|
December 6th, 2009 03:52 PM
by Jill
|
2 |
98 |
|
|
for Garys Student by
stew
Hi again
Small problem, which may be a big Problem
in o49
=LEFT(M49,FIND(" ",M49)-1)
when applied to
St Mirren v Falkirk,Returns
ST
The p49
=MID(M44,FIND(" v...
|
December 6th, 2009 02:55 PM
by stew
|
2 |
85 |
|
|
Unlocking right margin by
GAleno2001
Not sure what button my sister pushed. But now I cannot move the right margin
to the right. The right margin is set at 6.19. The left margin I can move to...
|
|
0 |
96 |
|
|
|
|
1 |
89 |
|
|
Move selection by
camlad[_2_]
XL 2003 'Tools' 'Options' 'Edit' 'Move selection after enter' and
one can alter what happens.
A visually handicapped friend has asked me to set his...
|
|
3 |
90 |
|
|
Gathering Info on one sheet by
albertmb
Hi everyone,
I have this problem: info is entered in 12 sheets (representing a sheet for
each month). The amount of rows used can not be determened...
|
|
1 |
115 |
|
|
height and width settings locked? by
Lab Teacher
Can row height and column width settings be locked in an Excel document
without blocking the user from entering/editing data in the cells?
|
|
3 |
127 |
|
|
Excel 2003 by
grikor1
In Excel how could I get a second cell to display only the decimal
part of the number in first cell?
Foir example cell C1 has the number 1.5678 and I want the...
|
December 6th, 2009 12:21 AM
by grikor1
|
4 |
86 |
|
|
|
December 5th, 2009 11:44 PM
by Erik
|
0 |
100 |
|
|
|
|
1 |
115 |
|
|
Text to date format by
pkeegs
I have a large file imported from another source into Excel (2003) with a
column of dates. The date column format is eg Mar. 09 1963 but some dates
only have...
|
December 5th, 2009 10:44 PM
by pkeegs
|
0 |
102 |
|
|
Associating a fill color with a cell value by
joshuare
Is there any way to make excel automatically change a cell's fill color if a
certain value is entered? I am making a schedule for employee shifts, and
would...
|
|
2 |
92 |
|
|
printing by
glenn
can i reset the print options to always print the entire workbook
|
|
3 |
109 |
|
|
|
|
2 |
103 |
|
|
Mail merge recipient list by
Dedicated
When I select the recipients from my data source (xcel spreadsheet), it
prints all of the recipients instead of just the few that I selected by
checking the...
|
|
1 |
107 |
|
|
Offset VLOOKUP results by
boardbug
VLookup returns a value in the same row. However, for my purposes I need the
value in a row ahead or a row behind.
So for example if Vlookup formula returns...
|
|
2 |
101 |
|
|
Time and Sum if by
Paul
I have a data logger that creates a spreadsheet. In one of the fields is the
date and time in 10 min increments, the other field is the pump output. I
want...
|
|
8 |
125 |
|
|
|
|
2 |
100 |
|
|
|
|
5 |
99 |