MS Excel Question

[explorian]

Does anyone have an idea how I can "grey" out all rows and columns that I am not using in a spread sheet? I do not want the empty row or column numbers to be visable. I have an example, but don't even know where to look to find the setting.

Thanks

 

[bekdik]

You could use something like tools/options and unclick the gridlines box, then you'd have to add cell boarders to those where you want to have the cell outlined.

Hope this helps

 

[explorian]

Thanks! This is a step in the right direction, however the example that I have, has only the columns and rows activated that are used in the layout. What I mean is that there are no more columns numbered after H and the no more rows numbered after 53. Instead of seeing the never ending grid, it is greyed out. Any ideas?

Thanks

 

[BobbyMac]

Thanks! This is a step in the right direction, however the example that I have, has only the columns and rows activated that are used in the layout. What I mean is that there are no more columns numbered after H and the no more rows numbered after 53. Instead of seeing the never ending grid, it is greyed out. Any ideas?

Thanks

Sounds like it is hidden. Select (by clicking and dragging your mouse along the topmost spreadsheet collumn header (labelled A,B,C...)) the last two collumns and right click on the last one, then select "unhide" from the popup menu.

 

[xtenda]

One thing you can do to make it simple is to highlight the column from which you wish to make hidden by clicking on the top reference you will see the entire column in highlight, then you would hold down shift and Ctrl at the same time press the arrow right now you should see your entire page highlighted then simply right click and select hide.

At this point all you will see is the columns you wish to work with and the rest will be invisible, you can do the same with rows by using the arrow down.

Hope this helps

 

[explorian]

Thank you very much!