Hello all,
I have worksheet in which there are datas from A1:A23 TO E1:E23.
I want to make that rows and columns to be visible.
Other cells should not be visible.
How to achieve this?
Hello all,
I have worksheet in which there are datas from A1:A23 TO E1:E23.
I want to make that rows and columns to be visible.
Other cells should not be visible.
How to achieve this?
Forgot this simple technique also.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Sure admin.
If you want to hide rows and columns in a worksheet which u don't want to be visible.
Use the following technique.
Select the Row below your row with data and press CTRL+SHIFT+DOWN arrow to select all the rows and right click and select hide.
For the columns, select the next empty column and press CTRL + SHIFT + RIGHT arrow to select all the remaining columns and right click and select hide.
Now only the cells with data will be visible in your worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks