Question about Apple Air Computers & Internet

1 Answer

How do I Freeze panes in MacBook Air - Air Apple Computers & Internet

Posted by Anonymous on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 47 Answers

In Excel on your MacBook Air? If so, try this video tutorial:

How to Freeze Pane in Excel on mac

Posted on Sep 03, 2014

Ad

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.
New users get 2 Free calls (no credit card required) and instant help on almost anything you can think of (from cars to computers, appliances, handyman, and even pets).
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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do I pair a Apple MacBook Air to Phonak compilot. I have the sennheiser adapter.


You would need to put your Compilot into pairing mode (see step 1 and 2 in the guide posted below. Ignore steps 3 -5) and then open system preferences on your Mac. In there you'll find a Bluetooth preferences pane and it will show you the compilot ready for pairing. It's pretty self-explanatory at this point.

http://www.phonak.com/content/dam/phonak/gc_hq/b2b/en/products/accessories/compilot/_documents/Quick_Guide_ComPilot_connecting_to_computer_029-0267.pdf

Jun 06, 2015 | Apple MacBook Air

1 Answer

Cant get my sound to unmute and i have no input and output options


System preferences has a pane for sound. The speaker icon at the top bar can control it. Any mac keyboard should have speaker icons to control sound.

If none of these work, your speakers may not be connected.

Mar 04, 2014 | Apple MacBook Air

1 Answer

In macbook air, my vodafone programme stops computer from shutting down


There are probably settings in the app -- perhaps in the system preferences pane -- that can be changed.

Feb 15, 2014 | Apple MacBook Air

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

1 Answer

How do I restore the startup chime on my MacBook Pro?


You could try using the startup sound preference pane located here: http://www.macupdate.com/app/mac/16425/startupsound.prefpane

Dec 04, 2010 | Apple MacBook Mac Notebook

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

On booting up my macbook pro I get a lot of


Do the patterns of distortion change as you are twisting and bending the laptop body? If so, you're dealing with a logic board issue. Probably your GPU is not soldered properly anymore. Go to the Genius bar first, if they can't help you can try a self repair or send it to a third party place. There is a free Macbook Air Repair guide that will show you how to do it. iPad Repair

Jan 26, 2010 | Apple MacBook Pro Notebook

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

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

Related Topics:

76 people viewed this question

Ask a Question

Usually answered in minutes!

Top Apple Computers & Internet Experts

Paul Carew

Level 3 Expert

2557 Answers

Martin Buck
Martin Buck

Level 2 Expert

85 Answers

Paul Bade

Level 3 Expert

1572 Answers

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

Answer questions

Manuals & User Guides

Loading...