If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I unhide columns
It's driving me crazy. I can't get columns to unhide after hiding them.
I have to go to the "select all" and then drag the columns open. It said something in Help about a column going to zero. How do I stop that so the UNHIDE will work? Thanks! |
#2
|
|||
|
|||
Hi Susan
if you have hidden columns C & D for example so you see A, B, E, F.... select the column letter B and drag across to E then right mouse click on B (or E) and choose unhide alternatively, if you really get stressed about hiding / unhiding columns you can use grouping instead, say you want to hide column C & D again select C drag across to the D and choose data / Group & OUtline / Group you're notice a little - above the letter E, click on it, C&D disappear to get them back click on the + i like this second method for where i'm hiding & unhiding the same columns (or rows) regularly. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Susan" wrote in message ... It's driving me crazy. I can't get columns to unhide after hiding them. I have to go to the "select all" and then drag the columns open. It said something in Help about a column going to zero. How do I stop that so the UNHIDE will work? Thanks! |
#3
|
|||
|
|||
If I hide columns A:G and want to unhide only E, I do this:
Edit|Goto (or ctrl-g or F5) type in E1 Format|column|unhide. If I wanted to unhide c:e, I'd type: C1:E1. Susan wrote: It's driving me crazy. I can't get columns to unhide after hiding them. I have to go to the "select all" and then drag the columns open. It said something in Help about a column going to zero. How do I stop that so the UNHIDE will work? Thanks! -- Dave Peterson |
#4
|
|||
|
|||
Assuming your column C is hidden..........
Left-click on the B at the top of that column and hold the left mouse swith down and drag the cursor over to also highlight column D. Then Right-click somewhere in the highlighted area and select Unhide............or, do Format Columns Unhide. Vaya con Dios, Chuck, CABGx3 "Susan" wrote in message ... It's driving me crazy. I can't get columns to unhide after hiding them. I have to go to the "select all" and then drag the columns open. It said something in Help about a column going to zero. How do I stop that so the UNHIDE will work? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Menu Bar Security and UNHIDING columns | AccessNana | General Discussion | 1 | August 29th, 2004 02:33 PM |
comparing data and return only data that exsist in the 2 columns | victorwill | Worksheet Functions | 2 | December 27th, 2003 12:13 AM |
Unhiding Hidden Columns | Bernie Beal | Worksheet Functions | 3 | October 9th, 2003 07:04 PM |