Are Hidden Rows/ Columns Included in a Sort?

G

Guest

I have 2 spreadsheets that I'm auditting line by line and need to re-sort
them now and again in sections for different views. I currently have certain
columns hidden to view them side by side and make printing easier.

My question is when I sort certain ranges, will it automatically include the
hidden columns that fall within the range of my sort or will they be ignored
since they're hidden?

Example: A, C, E, F are hidden. My sort includes B - M. Will the columns
C, E, F that are hidden be sorted with the rest? I know A will not unless I
unhide it, which I can live with; it's the middle information I need to keep
together.

Thanks for the info.
 
G

Guest

Hi N
Neither hidden rows or columns are included in the sorting process.

Regards
Michael M
 

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

HIDDEN ROWS 6
Sort partially hidden data 1
sort column data with hidden columns - excel 2003 2
Excel help for hidden columns 3
Sort Contiguous Columns - Danger 3
Cannot unhide the hidden rows in my spreadsheet 3
how many columns are included in a standard sort in Excel? 1
Hidden Columns & Rows in a Shared Wookbook 3

Top