|
|
Protection by
james
I know its basic but how do i protect a sheet so that when i delete an entry
i dont delete the formula?
Thanks
James
|
April 19th, 2010 10:19 PM
by JLatham
|
1 |
229 |
|
|
TimeStamp by
Chris
I currently have a spreadsheet set up that employees use to timestamp their
login, logout, lunch, etc. I have a button on the spreadsheet and a user
chooses...
|
April 19th, 2010 10:15 PM
by Chris
|
2 |
198 |
|
|
|
|
1 |
246 |
|
|
|
|
3 |
228 |
|
|
Column link by
james
This is great!
Ok Next question:
I need to link every cell in column e worksheet 1 with every cell in column
j worksheet 2.
Its for closing balance in Jan,...
|
April 19th, 2010 09:54 PM
by james
|
2 |
216 |
|
|
Microsoft Excel by
Toes
Can anyone please help me with the following error message:
The cell currently being used contains a constant.
There are no spaces before or after.
|
April 19th, 2010 09:52 PM
by Billns
|
1 |
202 |
|
|
|
|
9 |
288 |
|
|
Excel 2007 text flash (or blink) by
D7666
This might have been asked before but if so I'm not finding it when I
use a google groups search, mainly because of either none or too many
answers returned...
|
April 19th, 2010 09:46 PM
by D7666
|
4 |
352 |
|
|
How to choose maximum value by
Omics
Hi, I am wondering if anybody can help me with this. I need to take some
information from Table 1 to a new table which I am working on.
For example, for...
|
|
7 |
239 |
|
|
Number format changes to date by itself by
Pillpshr
I opened a spreadsheet saved earlier in the day. Nearly all of the cells
containing numbers that had been formatted as "number" changed to a custom
date...
|
|
0 |
186 |
|
|
grouping data in pivot tables by
Johnson748r
I am trying to group some dates in a pivot table, however when I select the
field, right click and select "group", I get an error - "Can't group...
|
April 19th, 2010 09:31 PM
by Mac
|
4 |
306 |
|
|
Excel 2007 Gridlines Disappeared by
Adel
The gridlines disappeared. I have confirmed background has "no color" and
all "show gridlines" are checked. I am out of options and think I may have
to...
( 1 2)
|
|
11 |
636 |
|
|
cell selection troubleshooting by
Moraga Betty
Every time I open my excel doc and try to click on just one cell, it and the
4 below it are selected. It doesn't matter where in the document I click,...
|
|
3 |
219 |
|
|
copy date in a cell if within a date range by
carrerapaolo
Column M is a listing of percentages
Column A is various dates, anywhere from Jan 1, 1998 to the present.
I need to copy the contents of let's say M3 into...
|
|
2 |
194 |
|
|
|
April 19th, 2010 08:51 PM
by Nat
|
0 |
190 |
|
|
Repeat formula by
james
Hi again, thanks for the help, im trying to repeat a formula for all cells in
a column, is there an easy way of doing this?
Thanks
James
|
April 19th, 2010 08:43 PM
by james
|
4 |
228 |
|
|
|
|
1 |
482 |
|
|
Disable macro selections under tools menu by
Jeremy
I have macros to automate on a sheet and want to disable the option to run a
macro under the tool selection on the menu bar. How would I do this?
Thank you
|
|
1 |
231 |
|
|
Adding some list items by
Jeremy
Hello, I have an easy one here that I cannot seem to figure out. I have a
simple list
A:A = Vendor
B:B = Amount
C:C = Category (from dropdown list)
What is...
|
|
1 |
257 |
|
|
|
|
1 |
351 |