how do I hide part of a column

W

Wayne

I want to Be able to hide columns AQ23 - AZ23 only can someone help with this.

Thanks Wayne
 
B

BigPig

Wayne,

You could try recording a macro. AQ23 - AZ23 refers to a specific cell
range, as opposed to columns. So I am assuming that you mean columns AQ:AZ.

Tools, macro, record new macro.

'Do your thing, in your case highlight the columns, right click, hide'

tools, macro, stop recording.

ALT + F11, click on modules, and you should see what you recorded.

Following that you could try: In design mode, insert command button
somewhere in your worksheet, double click the command button, insert/paste
the macro you recorded earlier. Exit design mode.
 
D

David Biddulph

You can't, but if you wish you can format the text in the cells to be the
same colour as the background so that the text is not visible.
 
B

Bill Ridgeway

Firstly, what you are wanting to do is to hide a range of horizontal cells
NOT a number of columns.

If row 23 is populated ONLY between AQ and AZ-
Take the mouse cursor to the row number (to highlight the entire row)
Click on <Format><Row><Hide>
to hide the entire row.

You cannot hide a range of cells. However, you could colour both text and
background white. That may keep prying eyes away. There may be other ways?

Regards.

Bill Ridgeway
Computer Solutions
 
G

Gord Dibben

Wayne

You cannot hide parts of columns or rows.

You can hide the contents of AQ23:AZ23 by formatting to Custom ;;; or changing
color to white.


Gord Dibben MS Excel MVP
 
W

Wayne

Thanks to all. I have a yearly chart that I wanted to hide so I could bring
up the month chart when my average macro is run.

Thanks again
 
Top