WebMay 8, 2012 · Re: Un-greying the greyed out area press Ctrl+A twice then right click a column header and choose unhide. Josie if at first you don't succeed try doing it the way your wife told you to Register To Reply Bookmarks Digg del.icio.us StumbleUpon Google Posting Permissions You may not post new threads You may not post replies WebDec 17, 2024 · I cannot unhide the greyed out area. I used the control shift down to select all below a certain row and hid for a specific function a while back but cannot undo. ATTEMPTS TO SOLVE: As you can see, trying selecting all rows and columns on the top corner and unhide doesn't work.
Un-greying the greyed out area [SOLVED] - Excel Help Forum
WebTip: Press Ctrl+F1 to show and hide your commands in the Ribbon. Click Show Tabs to display the Ribbon tabs without the commands. To access the commands in the Show Tabs option, click any of the tabs. Click Auto-hide Ribbon to hide all tabs and commands. By using this option, you get the largest amount of screen space when you view your workbook. WebSep 1, 2024 · What i want to have is the "Unhide All" button greyed out when there are no hidden sheets and enabled/active when there are hidden sheets. A context sensitive control. The challenge is what event to use to trap the "Right clicking of the sheet tabs" to know to run the macro to add the "UnhideAll" control to the right click menu deep blackheads on nose
How to quickly grey out all unused area in Excel? - ExtendOffice
WebMay 12, 2024 · ' unhideallcolumns Macro ' selects all cols of current worksheet and unhides them. Columns ("A:XFD").Select Selection.EntireColumn.Hidden = False End Sub To create views with particular rows visible or hidden there's now a … WebJul 7, 2024 · On the Home tab, click Format > Unhide Rows (the traditional way). How do I unhide a greyed out cell in Excel? You may also perform the steps below: Use Alt+F11 to … deep black shiny countertops