Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I copied a spreadsheet that ranged from A to K. All the remaining columns
after K were grayed out and that made the sheet easier to read. I can't figure out how to do it to the new sheet. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi,
select columns L:IV. right click the sheet, click hide. the cell are still there, just hiden. Regards FSt1 "riverdog" wrote: I copied a spreadsheet that ranged from A to K. All the remaining columns after K were grayed out and that made the sheet easier to read. I can't figure out how to do it to the new sheet. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Click in the L of column L to high light the column.
Press Shift CTRL and the right arrow, that will highlight all the columns from L to the end. Then right click on one of the column headers and select Hide. Hope this helps "riverdog" wrote: I copied a spreadsheet that ranged from A to K. All the remaining columns after K were grayed out and that made the sheet easier to read. I can't figure out how to do it to the new sheet. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select columns L:IV (in xl2003)
format|column|hide riverdog wrote: I copied a spreadsheet that ranged from A to K. All the remaining columns after K were grayed out and that made the sheet easier to read. I can't figure out how to do it to the new sheet. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
what to do with unused cells | Excel Worksheet Functions | |||
Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
How to hide unused cells when running accumulated totals | Excel Worksheet Functions | |||
Is there a way to cut off unused cells on a sheet | Excel Discussion (Misc queries) | |||
how get rid of cells with unused formulas | Excel Discussion (Misc queries) |