Alignment issues

ollyhughes1982

Well-known Member
Joined
Nov 27, 2018
Messages
760
Office Version
  1. 365
Platform
  1. MacOS
Hi.

I have an issues with alignment in the worksheet below. .For some reason the column headers have started behaving strangely. You can see, even thogh they are centre aligned and columns are plenty wide enough they have started to be misaligned. Please help! They have all of a sudden done this for no reason! They were fine until today. You can see examples of the issue in cells F3:T3.

https://1drv.ms/x/s!AtIvkRgReIvwgQhfThOxLb6dmnkA

Thanks.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Which sheet are you talking about?
They look fine to me.
 
Upvote 0
[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]
Event #1 - Age-Grade
(LPF Adjusted)
[/td][td]
Event #2 - Age-Grade
(LPF Adjusted)
[/td][td]
Event #3
-
Age-Grade
(LPF Adjusted)
[/td][td]
Event #4
-
Age-Grade
(LPF Adjusted)
[/td][/tr]
[/table]


which one is ok for you?
if two first - replace two first LF with spaces, set columns width to 13
 
Upvote 0
They're fine for me


Excel 2013/2016
FGH
3Event [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] - Age-Grade (LPF Adjusted)Event [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=2]#2[/URL] - Age-Grade (LPF Adjusted)Event [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=3]#3[/URL] - Age-Grade (LPF Adjusted)
Age-Graded League
 
Upvote 0
Strange. Can't understand that. I'm on a mac, But until today have displayed correctly
 
Upvote 0
It was the hash making it behave funnily. I have used the standard one (alt+3) and it now works. thanks
 
Upvote 0
Glad you sorted it & thanks for the feedback
 
Upvote 0
My office alsuite d******ed an update yesterday and I think that must have triggered a problem with that particular character. Thanks for the help
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top