Question about Microsoft Office 2007 Basic for PC

1 Answer

EXCEL 2007 sheet is slow in enter data

Sir, I have filled about 200000 cell with data. The problems is slow in entering data like filter, sort etc. How can I get faster fill data

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 189 Answers

This is lot a excel can hold, i dont know how much is the memory of your PC but this is too loarge to hold in memory. Thats why its getting slower.

Posted on Mar 13, 2009

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

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

1 Answer

I can not use Dragging actions of mouse in m.s.2007 excel. I unable to drag mouse, auto numbering, auto dates , cut paste etc in m.m. 2007 excel sheet


In Excel 2007 click on Office button where File used to be, then click on Options at the bottom, then on Advanced at the left, then under Editing Options choose the option Enable fill handle and cell drag-and-drop.

I think this should take care of the situation

Jul 10, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Excel question


You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Aug 19, 2008 | Excel (SS8SATAS5128400R)

1 Answer

EXCEL2000 PROBLEM


I think I have a way for you to get this done. Open a.xls and then open b.xls. In b.xls, create a formula in any cell that you want to be updated based on the data in a.xls. For example, if you want cell A1 in b.xls to stay updated with the data from cell A1 in a.xls, your formula in A1 of b.xls would look as follows:
[a.xls]Sheet1!$A$1

You can also create such formulas by following these steps:
1) Open a.xls and then open b.xls.
2) Place your cursor in the cell that you want to update dynamically in b.xls.
3) Enter the equals sign ("=").
4) Click on the "Window" menu in the top menu bar.
5) Select a.xls from the bottom of the menu items in the Window menu.
6) Click on the cell that contains the data that you want.
7) Hit Enter.
If you do all of these steps, you should find yourself back in b.xls with Excel having created the right formula for you. As a test, you can switch to a.xls and make a change in the source cell, and then you should be able to switch back to b.xls and see that same update.

Good Luck, hope this meets your need!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

1 Answer

Validation using Excel VBA code


Thats a lot of form work to be expecting out of Excel. You might be better off using Access, creating a table. If you need to export it back to a spreadsheet you can. The validation controls are better in Access and don't have a lot of limitations to them.

Good luck on that

Jul 21, 2008 | Microsoft Office Professional 2007 Full...

5 Answers

Forgot password to open Excel sheet


If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

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

5 Answers

Formula required


at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

1 Answer

Excel Sort Across Sheets


Hi Raymond, I have a solution for you. Asuming your 'main' sheet is Sheet1. On Sheet2, in the same line as your data on sheet1 (i.e. A5 on sheet1 is JIM), then on A5 on sheet2, enter a link ( the = ) and enter. copy this formula down. Do the same with Sheet3 linking to Sheet1. When you sort Sheet1, Sheet 2 and 3 will follow. Hope this helps. Regards DeltaC

Sep 11, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office 2007 Basic for PC Logo

Related Topics:

244 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18346 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...