Windows 10: How do I alphanumeralize sheets within a spreadsheet?

I am trying to organize the tabs in my spreadsheet numerically, I have 125 tabs

:)

 

Better overview of different sheets in Microsoft Excel

I would like to suggest you a simple method to create Hyperlink of Sheet Name for easy navigation.





How it works:

• Press Ctrl+K to open the Insert Hyperlink dialog box.
  
• Click the Place in This Document button.
  
• Then link to the sheet, select Sheet name from Cell Reference & press OK.
  
• In Type the Cell reference write the Cell address which you want to
  attach with Sheet's Hyperlink.
  

Note,

• Repeat Step 1 to 3 for other Sheets.
  
• Using this method you can create Sheet's Name list in desire order.
  

 

How can I print a Half Sheet (5.5 x 8.5 inch) paper in Excel Office 365

Hi MarshaTravis,



Thank you for posting your question in the Microsoft Community.



I would suggest you to follow the below steps, to print a Half Sheet paper in Excel.

1. Open the Excel Spreadsheet.
   
2. Go to File, click on Print.
   
3. Under the Print Settings, select the option "Custom Scaling".
   
4. Then select the option "Custom Scaling Options".
   
5. Under Page tab, select the option "Adjust to:" Change the value to 50%.
   
6. Click OK, and try to print the Excel paper.
   

Hope it helps,

Let us know if you got the help you needed by clicking Yes Or No

 

Current active users that are friends

The other reason I suggested this is that users can add characters to their username that are not alphanumeric (e.g. user*). This confuses things somewhat when looking at the list.