| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Cells
If I have cells filled with information as an example A1:G49 and then
A60:G100... with no information in the cells inbetween them, is there a way that i could hide them without having to hide everything below the first set. I really hope that makes sense... it does to me, let me know... thanks Jared |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Cells
You should be able to highlight the blank rows (50 to 59) and
'format'...'row'....'hide' "Jared Jenner" wrote: If I have cells filled with information as an example A1:G49 and then A60:G100... with no information in the cells inbetween them, is there a way that i could hide them without having to hide everything below the first set. I really hope that makes sense... it does to me, let me know... thanks Jared |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Cells
Hello, it is not possible to hide single cells, only entire rows or columns. If you have entire columns or rows that are empty do you want to a) hide them so that they are invisible and can still be referred to or rather b) get rid of them by deleting them? Alex -- Alexball ------------------------------------------------------------------------ Alexball's Profile: http://www.excelforum.com/member.php...o&userid=37072 View this thread: http://www.excelforum.com/showthread...hreadid=567922 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding blank cells when no results | Excel Worksheet Functions | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Hiding cells on condition | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Hiding Formula in cells | Excel Discussion (Misc queries) | |||
Linear Mode
