Ask a new question

Excel: A1 as default when opening new document

Is there anyway to set A1 cell as default when opening a new Excel sheet? Everytime when I open a new Excel document, E7 cell is selected.

I am using the following:
- Microsoft Office Professional Plus 2016 (MSI)
- Windows 10

Thank you in advance!
PS: I do not have a lot of experience with Excel.
Answer
Answer

Hi,

I am an Independent Advisior here to help you.
Starting workbook:
If you often work with the same workbook, you can open it and launch Excel at the same time. Simply save the file in Excel's XLSTART folder. If you're using Windows 10, you can find the folder here:
C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART
Excel bases all new workbooks on a template.
Modifications you make to Book.xltm are present in all new workbooks. Simply make the changes you want to persist in all new workbooks and then save the file appropriately as a template:
So make sure to select A1
Click the File tab and choose Save As.
Enter book as the filename.
Choose Excel Macro-Enabled Workbook (*.xltm) from the dropdown.
Use the browsing bar above to select your local drive (probably C:) and then enter the path to XLSTART
Please let me know I'm happy to try to solve your problem.

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 6, 2025 Views 1,705 Applies to: