Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2023, 06:58 AM
kilroyscarnival kilroyscarnival is offline How do I set the height for multiple rows at the same time? Windows 10 How do I set the height for multiple rows at the same time? Office 2021
Expert
 
Join Date: May 2019
Posts: 363
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

You can do this several ways:

Highlight a bunch of consecutive rows; then select the bottom border of the topmost row and drag it down manually. All the selected rows should resize to the same height.

Select any number of rows or cells (to select non-contiguous rows, hold down the Control key and cherry pick several cells), then go to the Format dropdown on your Home Ribbon, select Row Height, and input the numeric value you want for those row heights.

If you're doing that adjusting over and over again, you'll want to create a template for that type of spreadsheet that requires the logo, or record or write a macro with those steps. You can assign a button on your QAT to that macro and adjust new sheets with the push of that button.
Reply With Quote
Reply

Tags
height, input

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Multiple Rows JHalter Excel 2 08-10-2022 05:11 AM
Word table set selected rows height eduzs Word VBA 0 09-06-2020 10:50 AM
Excel Worksheet is not displaying data and rows are changing to 409.5 height instead of the 13.5 needexcelhelp Excel 1 06-18-2017 12:48 PM
How do I set the height for multiple rows at the same time? Calculate counts between fluid rows - TIME rgauss Excel 3 01-18-2017 04:09 PM
How do I set the height for multiple rows at the same time? Copy Multiple Rows to new workbook when multiple criteria is met. flds Excel Programming 5 09-30-2014 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:37 AM.


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