Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hide column and rows
In my spreadsheet, I just want to show some rows and some columns and hide the rest. For example, I want to show column A- F and row 1-50 and hide the rest .How should I do it ? -- m_johnPosted from - http://www.officehelp.in |
#2
|
|||
|
|||
hide column and rows
Select A51:IV65536, do formatrowshide, select G1:IV50,
do formatcolumnshide -- Regards, Peo Sjoblom "m_john" wrote in message ... In my spreadsheet, I just want to show some rows and some columns and hide the rest. For example, I want to show column A- F and row 1-50 and hide the rest .How should I do it ? -- m_johnPosted from - http://www.officehelp.in |
#3
|
|||
|
|||
hide column and rows
m_john Wrote: In my spreadsheet, I just want to show some rows and some columns and hide the rest. For example, I want to show column A- F and row 1-50 and hide the rest .How should I do it ? -- m_johnPosted from - http://www.officehelp.in Hi m_john Select columns G-IV, then Format Columns Hide, select rows 51 - 65536, then Format Rows Hide -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=482231 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
Want to auto hide rows in excel when no data in a certain column. | Excel Discussion (Misc queries) | |||
moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |