Solved

Is it possible to make row height static in Excel 2010

Posted on 2014-11-10
6
105 Views
Last Modified: 2014-11-12
I have differing row heights depending on the data contained in the rows.

Every time I insert a new row it changes other rows to the default height.

Is there a way to make row heights remain static?

Thanks
0
Comment
Question by:Jagwarman
6 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40432467
No, it can always be adjusted. There is no "lock" option on row heights.
0
 
LVL 31

Expert Comment

by:Rob Henson
ID: 40432512
You can stop users formatting rows, including height, by protecting the worksheet. I don't believe this will stop any auto adjustment though.

Thanks
Rob H
0
 

Author Comment

by:Jagwarman
ID: 40432617
Hi Rob

Users need to be able to insert rows but thanks
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 7

Expert Comment

by:tomfarrar
ID: 40432839
0
 
LVL 7

Accepted Solution

by:
slubek earned 500 total points
ID: 40432845
Use SelectionChange method:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Rows(3).RowHeight = 20
End Sub

Open in new window

0
 
LVL 31

Expert Comment

by:Rob Henson
ID: 40432953
In the Protect Sheet dialog, there are various options that the user can still do after protection is applied; one these is to allow users to insert rows.

Thanks
Rob H
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now