Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi I am working on a spreadsheet that was created by someone else.
In this sheet there are no cell reference headers for the rows or columns. Also, all cells to the right and below certain points are greyed out and I cannot access them. Can I show cell reference headers? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
for the headers, on the 2003 menu bar..... toolsoptionsview tabcheck row&column headers. for the access to gray area, ???? can you click in the gray area? the cells may be just colored gray. post back with more details on gray area. Regards FSt1 "Alofthedunnes" wrote: Hi I am working on a spreadsheet that was created by someone else. In this sheet there are no cell reference headers for the rows or columns. Also, all cells to the right and below certain points are greyed out and I cannot access them. Can I show cell reference headers? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In xl2003, you can try:
tools|Options|view tab|check row & column headers. And it kind of sounds like the author of the workbook just hid the columns to the right and rows below. You can select all the cells (ctrl-a a few times) Then Format|column|Unhide and format|row|unhide (still xl2003 menus) Alofthedunnes wrote: Hi I am working on a spreadsheet that was created by someone else. In this sheet there are no cell reference headers for the rows or columns. Also, all cells to the right and below certain points are greyed out and I cannot access them. Can I show cell reference headers? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |