Question about Apple Computers & Internet

1 Answer

How to freeze 2 or more rows in excel using mac desk top

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

Click on second row
how to freeze 2 or more rows in excel using mac de - febba622-a6d7-4d94-a649-06e01d10f50d.png
then chose freeze panes from menu
15adc35b-11ee-4a5e-8bab-8bdc8a12cdf5.png

Posted on Nov 30, 2013

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Cursor is stuck in the middle of the page and will not move to the left side. The back space button or the shift left button do not respond?


You've probably "frozen" your pane. "Freeze Panes" is a feature which allows you to keep one or more left-hand columns or top rows visible while you scroll through your worksheet.

When you ac

You didn't say which version of Excel your're using, but in Excel 2007, you can either freeze the Row 1, Column A, or any number of rows and columns based on which cell is selected (i.e., where your cursor is) when you click on "Freeze Panes."

In Excel 2007*, the way to fix this would be to click on the "View" tab, then the "Freeze Panes" icon, which will give you several choices. Click on "Unfreeze Panes." There you go.

* The steps are similar in other versions.

Aug 27, 2013 | Microsoft Excel for PC

1 Answer

Cell freeze 3 rows together at a time.


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

Aug 14, 2013 | Microsoft Office Computers & Internet

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    If I have a multi-row s/s that has multiple pages, how do I get the row title for columns to appear on each page?


    Hi, I believe you're asking about 'freezing panes'...

    In Microsoft Excel 2007:
    1. Select the place on the spreadsheet where you want the row titles to appear
    2. Click on the View tab
    3. Click on Freeze Panes button
    4. Select Freeze Panes
    Or, you could be asking about defining print rows to appear at the top of each page:

    1. Select the Page Layout tab
    2. Click Print Titles
    3. Enter the Rows to Repeat at Top (e.g., 1:3 for the first 3 rows)
    Hope that helps!

    Feb 01, 2011 | Microsoft Excel for PC

    1 Answer

    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.

    Dec 02, 2010 | Microsoft Computers & Internet

    1 Answer

    When I freeze a pane (at E6), the dropdown menus in column B no longer work.


    HAHAHA I figured out how to freeze the left column successfully on excel for MACS.... So select the cell that is one column to the right and one cell below the column you want to freeze. So if you want to freeze the A column From row 1 - 35, select B36. Get it?? Took me forever, but i figured it out!!! I still have no clue how you could freeze a header row as well, but this is enough for me

    Feb 10, 2010 | Apple Mac Pro Desktop

    3 Answers

    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! :-)

    Apr 09, 2009 | Apple Mac Pro Desktop

    1 Answer

    Does the Graph/Chart option exist for Mac Excel?


    Yes, it does.

    Choose the data in which you want to graph by highlighting said data, including and row/column headings. Then click the icon, which looks like a graph, in the top toolbar which will open up the Chart and Graph Wizard. Then follow the steps and guidelines to create your chart or graph.

    Hope this helps. Have a great evening!

    Feb 17, 2009 | Microsoft EXCEL 2004 for Mac

    1 Answer

    Freezing column and rows simultaneously


    in Excel
    go to window/split; move the bars to the row and column you want to freeze; the go to window/freeze panel

    Jan 06, 2009 | Computers & Internet

    Not finding what you are looking for?
    Computers & Internet Logo

    Related Topics:

    53 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Apple Computers & Internet Experts

    paulcarew

    Level 3 Expert

    2458 Answers

    Martin Buck
    Martin Buck

    Level 2 Expert

    82 Answers

    Paul Bade

    Level 3 Expert

    1516 Answers

    Are you an Apple Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...