Windows 10: Help needed with Excel Attendance Sheet

So I have this attendance sheet, with this formula for the days of the month, based on this CONFIG sheet, but id like to make the MONTH cell a drop down list, that would change the formula in F16 based on the selected month in the list.



ALSO
And this seems a bit greedy but id also like it if when I selected a month like February that has 28 days, or any month that has less than 31 days, the 31st day column to be automatically hidden, and if after that I selected a month with 31 days, It should be un-hidden, which from my research the only way to do that would be to use a MACRO command which I have little to no understanding about.

Any help is greatly appreciated, and id settle for just the month drop down list!

:)

 

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

 

EXCEL SHEET IN MAP XML FILE DELETE IN EXCEL SHEET

EXCEL SHEET IN MAP XML FILE SO EXCEL SHEET WORKING NO PROPERLY SO I HAVE DELETE XML MAP IN EXCEL SHEET