Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2022, 08:21 AM
oscarlimerick oscarlimerick is offline Setting up alignment Windows 8 Setting up alignment Office 2013
Advanced Beginner
Setting up alignment
 
Join Date: Jul 2020
Posts: 47
oscarlimerick is on a distinguished road
Default Setting up alignment


Hi folks, can anyone tell me how to set up alignment? Whenever i open an excel spreadsheet the default alignment for all cells is bottom align and align right, and i usually want top align and align left. I know I can go in and change this setting from the alignment section, but is there a way to have excel automatically open up the worksheet and have it aligned as top align and align left? Many thanks
Reply With Quote
  #2  
Old 05-06-2022, 09:05 AM
oscarlimerick oscarlimerick is offline Setting up alignment Windows 8 Setting up alignment Office 2013
Advanced Beginner
Setting up alignment
 
Join Date: Jul 2020
Posts: 47
oscarlimerick is on a distinguished road
Default

I think I found a solution on another website so I will mark this as solved. Here is what I found, it seems to work for me:

How to change default page alignment on excel startup:
1. Change Default Alignment Settings
Hello there,

I have successfully been able to change the alignment settings in microsoft excel to the left and the top but I have to continue to do that for each cell or groups of cells in the excel document.

I wanted to know if there was a way that I would be able to change the default settings so that every time I open excel it always aligns to the top and the left (similar to page layout options in word).

Thanks to anyone that can help.

-BB
Register To Reply
2. 07-23-2019, 06:00 AM#2
Aardigspook

Forum Expert
Join Date
03-20-2015
Location
Primarily UK, sometimes NL (COVID allowing)
MS-Off Ver
Work: Office 365 / Home: Office 2010
Posts
2,402
Re: Change Default Alignment Settings
Welcome to the forum.

You can do this by creating a template which has your preferred options set.

1. Open a blank workbook.
2. On the 'Home' tab, in the 'Styles' section, right-click on the 'Normal' style. Set the options the way you want.
3. Save the file as an 'Excel template (*.xltx)' and call it 'Book.xltx'. Don't close it yet.
4. Now save the file again, this time as 'Sheet.xltx'.
5. You need to put these two files into your XLstart folder. To find it, copy and paste this into the address bar of File Explorer: %appdata%\microsoft\excel\xlstart
(It's a hidden folder, so you may need to enable viewing hidden folders first.)
6. Copy the two files you just made into this folder.

Book.xltx will now be used whenever you open a new file.
Sheet.xltx will be used whenever you add a new sheet.


In step 2, you can set any other options you like, such as the theme (to set default fonts), margins and so on.


I've seen some reports that in newer versions of Excel, it won't use 'Book' if you just click 'blank workbook' from the start screen. To get it to use your now-perfect 'Book' you first have to disable the start screen by going to 'File' → 'Options' → 'General' → 'Start up options' and then un-select 'Show the start screen when this application starts'. I haven't had this problem myself (I use 2010) but I include the info just in case.


Hope that helps.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alignment of sentences aditya@office Excel 11 09-24-2019 06:22 AM
Setting up alignment Footnotes Alignment dddx Word 5 04-10-2017 10:36 PM
Setting up alignment Alignment issue malick90 Word 1 01-22-2015 07:02 PM
Setting up alignment alignment and pagination run michgyver Word 2 12-08-2014 05:53 AM
Right Alignment Andy Pilkington Word 3 09-09-2014 10:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft