Quote:
Originally Posted by BobBridges
Officeboy, Peco's solution hides those cells. (They're not gone, they just have their display width reduced to 0; you can get any of them back by reversing that.) That may be the way you like best to accomplish it.
But you did say "grey out". If you meant it literally, the only way I've found to do it (and it's a technique I used to use often) is to grey out the entire worksheet, then ungrey the columns at the left that I'm actually using. This allows me to see the helping columns at the right while providing a strong visual cue to my eyes which columns are which.
To grey out a whole sheet, select the entire range (hit <Shift-Space>,<Ctrl-Space> or click the button in the upper left corner), then use the Format Cells dialog with "Fill" colors. Pick the shade of grey you want. Then, as I said, change the "usual" columns back to "No Color".
When you select a fill color, that cell no longer has the mild grey border that marks it from its fellows. Most people can live with that, but I usually change the borders on such cells back to a light grey, which is the one that matches uncolored cells. You can make your own mind up about that.
|
Thankyou! What I'm actually doing is to make a document in excel for printing. I selected 'Over then Down' as the way it prints. And I adjusted the column widths so that, for example, A to E fit in the 1st page and F to J fit the 2nd. But I don't want it to display too many pages across the top of the worksheet. I want it to go over just two pages then down for the 3rd and 4th, and so on. This is why I need to know how to hide the columns that are not being used.
Filling the worksheet with mild grey can make the cells in the unused columns unseen. But this doesn't hide the column headers of the unused columns. That probably means excel would still regard those grey-out columns as 'active' on the worksheet. So, it might continue to go over across many columns when it prints.
Or, do you have any better suggestion for doing this task?