I have an Excel file that is only using 5 columns and 10 rows. How can I hide the unused column and rows? I know how to highlight the unused columns and rows and right-click hide, but was wondering if there another method. BTW, column A and row 1 is blank. Data starts on column B and row 2.
Since there are only 5 columns and 10 rows being used, can I disable scrolling without using VBA?
Since there are only 5 columns and 10 rows being used, can I disable scrolling without using VBA?