Question description:
This user has given permission to use the problem statement for this
blog.
Column widths in different spreadsheets with the same width don't appear the same base on the text in each. Is it possible the scale of the sheet or width changed?
Solved by V. S. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
11/04/2018 - 01:52
hi
User
11/04/2018 - 01:53
Hello.
Excelchat Expert
11/04/2018 - 01:53
welcome to got it pro
Excelchat Expert
11/04/2018 - 01:54
just give me a minute
User
11/04/2018 - 01:55
Sure.
Excelchat Expert
11/04/2018 - 01:58
yes
Excelchat Expert
11/04/2018 - 01:58
you can just select all the columns at once and set their width
Excelchat Expert
11/04/2018 - 01:59
by selecting the column and right clicking on it you can specify the width
User
11/04/2018 - 02:00
The issue is when I copy information from one spreadsheet to another and adjust the column widths to match, the text doesn't fit in the column where I copied the text to.
User
11/04/2018 - 02:00
It's like the scale is not the same between the two spreadsheets.
Excelchat Expert
11/04/2018 - 02:00
if the text is long it would not adjust with in the width
Excelchat Expert
11/04/2018 - 02:00
may be font size by default is different in both the sheets
Excelchat Expert
11/04/2018 - 02:01
or you might be viewing one sheet at below 100% zoom
Excelchat Expert
11/04/2018 - 02:01
these could be the only reasons for difference in width behaviour of two sheets
Excelchat Expert
11/04/2018 - 02:01
hope this helps you
User
11/04/2018 - 02:02
I changed the font for each to be the same and had the same zoom (75%).
Excelchat Expert
11/04/2018 - 02:02
then it should be the same in both
Excelchat Expert
11/04/2018 - 02:02
can you send me the excel to have a look
User
11/04/2018 - 02:04
That is my dilemma! Unfortunately, the file is at my office. How do you change the default font size?
Excelchat Expert
11/04/2018 - 02:05
can change from settings
Excelchat Expert
11/04/2018 - 02:06
https://www.mcstech.net/changing-the-default-font-in-excel/
Excelchat Expert
11/04/2018 - 02:06
follow this to change default font size
User
11/04/2018 - 02:06
Thanks.
Excelchat Expert
11/04/2018 - 02:06
u r welcome
Excelchat Expert
11/04/2018 - 02:07
Please do give good rating
Excelchat Expert
11/04/2018 - 02:07
it really helps
User
11/04/2018 - 02:10
My Excel says the default is Body Font.
Excelchat Expert
11/04/2018 - 02:10
you can change the font as well as font size
Excelchat Expert
11/04/2018 - 02:10
default will be body font
Excelchat Expert
11/04/2018 - 02:11
you will need to change it
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
