For example, I have the cells in Row 1, Columns A, B, C, and D as 1" by 1" . What I am looking for is to have the cells in Row 1, Columns A, B, C, and D bet set as 1" by 1 but the cells in Row 1 Columns G and H to remain the default Excel size. Can this be done?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I change the width of some cells in a row but not all of them?
Leith Ross
Well-known Member
- Joined
- Mar 17, 2008
- Messages
- 1,874
- Office Version
- 2010
- 2007
- Platform
- Windows
Hello AdamW328,
Whenever you adjust a column's width, it will change in all rows. Conversely, changing a row's height will affect all columns the same.
Whenever you adjust a column's width, it will change in all rows. Conversely, changing a row's height will affect all columns the same.
Upvote
0
RoryA
MrExcel MVP, Moderator
- Joined
- May 2, 2008
- Messages
- 43,075
- Office Version
- 365
- Platform
- Windows
- MacOS
You can have different widths in the same row quite easily - just amend the column widths as desired. If you want different heights in the same row, you'd have to merge cells, which is not something I would generally recommend.
Upvote
0
Similar threads
- Question
