Question about Microsoft Office Excel 2007

1 Answer

I'm trying to type in numbers as I did in 20003

I'm trying to type in numbers as I did in Excel 20003 version can't find format menu in 2007 version

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.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 51 Answers

You will find that the options that were in the format menu in 03 can now be found on the home tab in 07. If you could be more specific on what you need to type, I can direct you accordinly.

Posted on Feb 01, 2010

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

How to convert .shs file to .xls format in office 07.pls help......


1. Open a blank Excel workbook by selecting "New" from the "File" menu.
2. Drag and drop the .shs file on to the new workbook by highlighting the scrap file icon on the desktop and dragging it onto the worksheet. Alternatively, you can copy and paste. To do this, click the scrap file icon, and then right-click and select "Copy" from the pop-up menu. Left-click on the Excel workbook, and then right-click and select "Paste" from the pop-up menu. The information stored in the scrap file should now appear within the worksheet.
3. Save the file. Select "Save As" from the "File" menu, and then enter a file name in the box at the top of the window that opens. By default, Excel saves files in the workbook format native to the version. For versions prior to Microsoft Office 2007, this is the .xls format. If you have Excel 2007 or later and want to save the file as .xls, select this format from the "Format" drop-down menu below the box where you entered the file name.

Feb 11, 2015 | Computers & Internet

Tip

How to convert older Office documents to Office 2007 format


<span> <p><span>The Office 2007 applications such as Word and Excel can open a spreadsheet or a document which is in an older edition of Office. They can open such older version documents in Compatibility Mode. However, if you need to make use of various newer features available in Office 2007, you will have to convert older Office documents to Office 2007 format. The feature to covert older Office documents to Office 2007 format is very useful. For example, you can now utilize 1.1 million rows in the 2007 version of Excel. In the older versions you could only use sixty-five thousand rows. The method to convert older Office documents to Office 2007 format is the same for all applications. Here we are using the example of a Word document of previous version. If you open a Word or Excel document of an older version, you see [Compatibility Mode] as part of the title.</span><br /> <p><img src="compatibility-model-excel.jpg" /> <span>Follow these steps to convert older Office documents to Office 2007 format:</span><br /> <span>Open the Word document which you want to convert into Word 2007 format</span><br /> <span></span> <br /> <span></span> <br /> <br /> <span>Click on the Microsoft Office button on the top left.</span><br /> <span>Click on Convert on the left hand side of the menu.</span><br /> <img src="convert-excel.jpg" /> <p><span>Click on the OK button on the Microsoft Word Office dialog box which appears. </span><br /> <p><img src="corverting-documents.jpg" /> <p><span>By clicking on the OK button, the document will be automatically converted into the Word 2007 format. You will notice that now the window does not show [Compatibility Mode] as part of the title bar any longer.</span><span> </span><br /> <p><img src="show-compatibility.jpg" /></span> <p><span><span> google_protectAndRun("ads_core.google_render_ad", google_handleError, google_render_ad); </span></span><br /> <p><b> </b><br />

on Dec 12, 2010 | Computers & Internet

Tip

How to convert older Office documents to Office 2007 format


The Office 2007 applications such as Word and Excel can open a spreadsheet or a document which is in an older edition of Office. They can open such older version documents in Compatibility Mode. However, if you need to make use of various newer features available in Office 2007, you will have to convert older Office documents to Office 2007 format. The feature to covert older Office documents to Office 2007 format is very useful. For example, you can now utilize 1.1 million rows in the 2007 version of Excel. In the older versions you could only use sixty-five thousand rows. The method to convert older Office documents to Office 2007 format is the same for all applications. Here we are using the example of a Word document of previous version. If you open a Word or Excel document of an older version, you see [Compatibility Mode] as part of the title.
google_protectAndRun("render_ads.js::google_render_ad", google_handleError, google_render_ad);
compatibility-model-excel.jpg Follow these steps to convert older Office documents to Office 2007 format:
Open the Word document which you want to convert into Word 2007 format.
Click on the Microsoft Office button on the top left.
Click on Convert on the left hand side of the menu.
convert-excel.jpg Click on the OK button on the Microsoft Word Office dialog box which appears.
corverting-documents.jpg By clicking on the OK button, the document will be automatically converted into the Word 2007 format. You will notice that now the window does not show [Compatibility Mode] as part of the title bar any longer.
show-compatibility.jpg

on Sep 03, 2010 | Computers & Internet

1 Answer

Reduce the size of excel file


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.


Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.

Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.


Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/
or
Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Computers & Internet

1 Answer

Unable to type in microsoft excel spreadsheet


Couple of possibilities:

The active window is selected.

Some cells might be formatted for numbers only. Check cell format.

Your font is white and you can't see your typing.

Oct 03, 2010 | Microsoft Office Excel 2007 Full Version...

2 Answers

My file is in excel 2007 i want to open in excel 2003 how would it happen or not


open the excel 2007 file in excel 2007 only and save as file.xls[xls is a 2003 version]

with this method u can open it though excel 2003
any issues kindly rate and revert

Jul 14, 2010 | Microsoft Excel 2007 Home and Student...

1 Answer

Lose excel formatting when save as it in 97-2003 format


If you are using Excel 2007 and saving your workbooks in the 97-2003 format, you should get a message that appears that will let you know what formatting will not be compatable. If you click ok, then the computer will automatically adjust the formatting to the closest fit for the earlier version to be compatible. Once you save it to an earlier version, then reopen it in excel 2007, you will not get your formatting back.

May 23, 2009 | Microsoft Excel 2007 0882224152648 Full...

1 Answer

Excel won't let me save my 2007 file in 2007 format


Is the top choice on the Save As menu "Excel WorkBook"? If so, then that is the 2007 version. It should change the extension on the saved file to xlsx

Apr 10, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Excel Charts in PPT 2003 and 2007 not working correctly


Have you tried uninstalling the beta, and possibly uninstalling and reinstalling your copy of Office 2003?

Jan 26, 2009 | Microsoft Excel for PC

3 Answers

Formulas in microsoft excel 2007


Excel 2007 has a rather elaborate formula pull down menu.it out,

Loringh

Nov 12, 2008 | Microsoft Excel for PC

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

Related Topics:

31 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2727 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18392 Answers

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

Answer questions

Manuals & User Guides

Loading...