Computers & Internet Logo

Related Topics:

Anonymous Posted on Aug 14, 2013

Cell freeze 3 rows together at a time.

I want to freeze 3 rows together at a time so that if any of the values in the group of 3 are filtered then all three values are also displayed. How is this done in excel 2007?

1 Answer

Brian Sullivan

Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

  • Microsoft Master 27,725 Answers
  • Posted on Aug 14, 2013
Brian Sullivan
Microsoft Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Joined: Jul 19, 2010
Answers
27725
Questions
1
Helped
5666026
Points
79191

Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.


Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns

3 Related Answers

Anonymous

  • 28 Answers
  • Posted on Dec 30, 2007

SOURCE: EXCEl 2007

Use the "IF" function. Help should give you all the examples you will need.

If this helps you, please rate me. Thanks, Patty

Ad

Anonymous

  • 15935 Answers
  • Posted on Jan 16, 2009

SOURCE: Excel Formula

Place the following in the cell you want to display the result:

=MAX(l15:l37)

Logically this reads the cells you have circled, reads the highest #, and places it in the cell you put the formula in. ( you have indicated cell m16 in the screencap)
Hope this is what you are looking for.

Anonymous

  • 4 Answers
  • Posted on Jan 16, 2009

SOURCE: Excel Formula

Highlight the range of cells that contain the numbers you want included. Click on the cell where you want the highest value displayed. Click on the paste function button select MAX and click <OK>

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

What is the meaning of rows?

In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:
sgoldberg08_1.jpg

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!
0helpful
1answer

How to freeze columns and rows on excel?

To freeze columns and rows in Excel, here's what you need to do:

- Excel 2003 & older: To do this, open your Excel spreadsheet. Select the cell that is below the left-most column heading that you wish to see. Then under the Window menu, select Freeze Panes.

- Excel 2007 & newer: Click on the View tab, and then on Freeze Panes. In here you have 3 options, first one does exactly the same thing as the one from older versions, second one freezes the top row and the last one freezes the first column.
1helpful
1answer

3 gs iphone working fine, clicked on safari , looking at website then it froze and now cannot move from the page or use the app at all , having to use the google app, safari now useless

Go to your setttings and open the Safari Option. Use the three options grouped together but on individual rows, "Clear History", "Clear Cookies", "Clear Cache".
Then do a hard reset on your Phone:
  • Press the "home button" and the "off button" at the same time, until the device goes off.
Turn your iPhone back on and see if this has helped. If it does not we have several other options.

jhh
0helpful
2answers

Ranking values based on the number of times they appear/repeat

=SUM(IF((Ax:Ay="xxxxx"),1,0) Ax=starting cell Ay=ending cell "xxxxx"=text"
141helpful
3answers

Freeze panes doesn't work in mac excel

HOW TO FREEZE THE TOP ROW OF EXCEL FOR MAC:

Wow - using the above ideas I figured out how to freeze the top row!!! Thanks guys!! Here's how:

1.) Use 'Normal' View (i.e. look up at tool bar, hover over 'View' and make sure 'Normal' is checked)
2.) Select cell B2 (only the cell, not the row or the column)
3.) Click 'Window' (from the tool bar at the top of your screen)
4.) Click 'Freeze Panes'

...et voila! :-)
0helpful
1answer

How do i multiply a value by a minimum amount

I you have a row with 6 values you can get the minimum number from that area. Example:
A1: 6
A2: 8
A3: 3
A4: 9
A5: 2
A6: 7

in B2 we want to pick the smallest value in that group and multiply it with 60. This is what you type in B2

=min(A1:A6)*60

Yeah :)
that's all.... Good Luck :)



0helpful
1answer
1helpful
1answer

HLOOKUP IN MS EXCEL

lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x
1helpful
1answer

Excel support

Hi,
Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970
The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.
The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.
Hope this helps.
Glad to be of assistance - please rate the solution I can learn from you. Thanks
0helpful
1answer

Macro

Hi alwinkumar

You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.

Private Sub resetForm()

'formname.itemname = value
UserForm1.Label1 = "Hello World"

End Sub

For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below

numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count
Not finding what you are looking for?

341 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...