Question about Microsoft Excel for PC

1 Answer

The auto filter that I have on my data is freezing and with it on I can't cut and insert rows ect. Has only just started happening and the spreadsheet as been in use for some time

Posted by on

  • garthtilly Nov 21, 2008

    can't copy or paste when the filters are frozen.

×

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
  • 45 Answers

You can copy and paste, but you cannot cut, insert or shift cells while in auto-filte.

Posted on Nov 21, 2008

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

Car cutting off


If you have no trouble lights and the car is displaying these kind of problems, why don't you return the car for repair ?

I would bring the car to a auto zone and have them but the car on the computer for a diagnostic check.

Also, if the car will not start after running, does it back fire or seem like its being choked out ?
Could be a fuel problem or restriction. ( FPR, Fuel Pump, Filter ect.

May 04, 2014 | Cars & Trucks

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

When you inaserrt a cell into a row,all data in that row is shifted down true or false?


With most spreadsheet programs, false. Of course, the data in that row below the insertion point is usually pushed down but not the data above.

Feb 28, 2013 | 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

    661m04-mx-6l foxconn motherboard i need a diagram to tell me where the pins go onto the motherboard the ground ones reset power hdd ect ect ect.


    All motherboards use the same pin connections for the front panel switches and led's.

    There is a nine pin connector. 5 pins on the top row 4 on the bottom.(orient the board to get this view)

    Starting with the top row , Pled+, Pled-, PWR SW, Ground. empty pin.

    Bottom row. HDLED+, HDLED-, Ground, Reset, dummy pin.

    Jan 09, 2011 | Computers & Internet

    1 Answer

    5vz-fe misfire codes


    Replace the coil pack.

    Dec 26, 2008 | 1999 Toyota 4Runner

    1 Answer

    Excel formulas


    insert a row above row 1 and use data>filter>autofilter
    view your database however you like

    Nov 18, 2008 | Microsoft Excel for PC

    2 Answers

    Duplicacy in excel sheet


    Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
    Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

    Drag this formula down column F till the end of your data
    Select the entire data and do an auto filter
    In column F filter the data by Duplicate and delete all these rows
    What remains should be unique data

    Dec 19, 2007 | Computers & Internet

    2 Answers

    Budgets in excel


    Dear Madiha35,

     

    I would recommend the use of the Table Function in Excel.

     

    Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

     

    Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

     

    Excel 2007 had a budget format workbook

    New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

     

    Step 1:  Enter your data into the worksheet.

     

    Step 2:  Create Table

                 Highlight the relevant data

                 On the insert tab, click on Table

                 

    Step 3:  Verify Table range is correct, Click OK

     

    Step 4:  Select the cell you where you wish to Sum Data.

             Click on Autosum.

     

    Step 5:  To Insert new data

             Click on the sum row in the table, (Not the entire worksheet row)

             Right click, Insert, Insert Table rows from above

     

    Step 6:  Enter new data in row

     

    Step 7:  Data is automatically calculated in formula.

    Oct 22, 2007 | Computers & Internet

    Not finding what you are looking for?
    Microsoft Excel for PC Logo

    Related Topics:

    46 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2644 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18381 Answers

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...