|
|
Mark Rows for scrolling by
Doug Mc
This seems weird!
I mark row 4 and row 1 and click on Freeze Panes.
Rows 1-3 become frozen.
There's also a black line below Row 6 that acts like another...
|
November 23rd, 2009 12:35 AM
by Doug Mc
|
2 |
141 |
|
|
What does =B11*$C$4 mean? by
David Deley
=B11*$C$4
I get the cell value equals cell B11 times——then what's the $ mean,
$C$4? I think it means use the value in cell C4, but what do the $ mean?
|
|
2 |
128 |
|
|
|
|
1 |
132 |
|
|
|
|
1 |
188 |
|
|
|
|
1 |
155 |
|
|
Macros for template by
Mike
I have a Template for the 52 Weeks that i created if i want to change
something in Template is it possible to have the 52 other sheets change as
well through...
|
|
1 |
120 |
|
|
52 Work sheets (Tabs) by
Mike
I have 52 work sheets named week 1 to week 2 once data is completed for each
week is it possible to have the tabs change colour automatically to indicate...
|
|
5 |
242 |
|
|
sum to = 1 for each cell by
Mike
I am trying to sum up 37 cells to = 1 each for each cell ex. if i put say 997
in cells i want them to = 1 each so that the sum total = 37 if i put 997 or
any...
|
|
2 |
98 |
|
|
Show top three rows when scrolling by
Doug Mc
I thought I knew how to do this but it didn't work.
I went to Page setup, Sheet and typed in $1:$3 but it didn't work.
What am I doing wrong?
Thanks in...
|
November 20th, 2009 11:25 PM
by Doug Mc
|
2 |
154 |
|
|
|
November 20th, 2009 11:18 PM
by Max
|
2 |
136 |
|
|
|
|
1 |
164 |
|
|
|
November 20th, 2009 05:02 PM
by cmiling
|
2 |
139 |
|
|
Password protected spreadsheet by
BobW
When I open a password protected to modify sheet, the dialog box says -
"filename.xls" is reserved by - followed by a blank line. How do I insert my
name in...
|
November 20th, 2009 02:25 PM
by Paul C
|
1 |
119 |
|
|
|
|
1 |
169 |
|
|
formatting of row depending on cell value by
RedBeard
Hello,
I would like to accomplish the following:
If a cell in Column A corresponds to a certain date, I would like to
have the row that cell is located on to...
|
November 20th, 2009 09:22 AM
by RedBeard
|
9 |
410 |
|
|
Blank Cells Have Data ? by
John Calder
Hi
I run Excel 2K
I have a spreadsheet that was downloaded from a mainframe source. (the
source allows saving data in an Excel format)
There is approx...
|
November 20th, 2009 03:09 AM
by T. Valko
|
1 |
145 |
|
|
Cant se some columns! Why? by
pcor
I have a spreadsheet that displays COL A and them col BL-BM-BN etc
How do I get to see the cols B to BK
I am working with EXCEL 2007
Thanks
|
November 19th, 2009 09:58 PM
by JLatham
|
1 |
134 |
|
|
|
November 19th, 2009 04:35 PM
by T. Valko
|
12 |
250 |
|
|
|
|
2 |
155 |
|
|
|
November 19th, 2009 12:46 PM
by JLatham
|
1 |
125 |