How to modify the look of the workbook.

  • Thread starter Thread starter Vipul
  • Start date Start date
V

Vipul

Hi there,

I have a workbook with only one sheet in it.
And i only need to use A1 : G50 range.
I want to disappear all other columns and rows.
How can i make my sheet come up with only A1 : G50 range.

I hope its possible because i have seen some sheets with this kind. But i
still couldnt find how can i do it.

Thanking you.
-Vipul
 
hi
the most popular way of doing this(i think) is to hide all unused columns
and rows.
another way is to set the cell back color and line to dark gray.
a flaw to the color method is that the cell pointer will run over into the
colored part where the cell pointer stops at the hidden columns/rows.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining Columns 7
how to reset the activesheet usedrange value 5
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Modify working code to expand the output. 5
Sound repeats unending until closing workbook 2
Want code to copy to ABOVE row 22 column A on sheet 1 10
split worksheet after empty row into separate workbooks 3
Code does not error but no copy either 4

Back
Top