Forum Discussion

Tzac17's avatar
Tzac17
Copper Contributor
Jun 02, 2023

Multiple problems with Sheet, hidden columns and heading on subsequent sheets.

I think have made a couple of mistakes on my sheet.   I have hidden columns that I wanted to delete. The delete column function was not working so I chose to hide the columns.     Now my sheet is pushed to the left and I can't undo.    The 2nd issue to I am trying to get a heading to repeat on subsequent pages and I have cannot get it to work.  Lastly I am trying to get the sheet of fill the entire page. I believe that the 1st issue is preventing the sheet from being maximized.  Any help would be appreciated. 

excel
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jun 02, 2023

    Tzac17 

    To address the issues you are facing in Excel:

    1. Hidden columns and alignment issue:
      • If you have hidden columns that you want to delete, you can unhide them by selecting the columns on either side of the hidden columns, right-clicking, and choosing "Unhide" from the context menu.
      • If the sheet is pushed to the left and you cannot undo, you can try adjusting the column widths to make the sheet fit properly on the screen. Select the columns on the left side, right-click, and choose "Column Width" to set an appropriate width.
    2. Repeating heading on subsequent pages:
      • To repeat a heading on subsequent pages when printing, go to the Page Layout tab in the Excel ribbon.
      • Click on the "Print Titles" button in the Page Setup group.
      • In the Page Setup dialog box, go to the "Sheet" tab.
      • In the "Rows to repeat at top" field, select the row(s) containing the heading you want to repeat.
      • Click OK to apply the changes. The heading should now repeat on every printed page.
    3. Maximizing the sheet to fill the entire page:
      • To maximize the sheet to fill the entire page when printing, go to the Page Layout tab in the Excel ribbon.
      • In the Page Setup group, click on the "Orientation" button and select "Landscape" if you want a wider layout.
      • Adjust the margins of the sheet by clicking on the "Margins" button and choosing "Custom Margins". Reduce the margins if necessary to maximize the sheet's content area.
      • Additionally, you can adjust the scaling of the sheet by clicking on the "Scaling" button in the Page Setup group and selecting an appropriate scaling option.

    By following these steps, you should be able to unhide columns, align the sheet properly, repeat the heading on subsequent pages when printing, and maximize the sheet to fill the entire page.

    If all this does not help, then a file (without sensitive data) or photos with a step-by-step description and knowledge of the Excel version, operating system, storage medium, etc. would be advantageous in order to be able to suggest something more precise.

Resources