Question about Microsoft Windows XP Professional

1 Answer

Microsoft Excel How Many Worksheet could we added in excel ?

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 1,901 Answers

The number is only limited by the physical memory of your system. Add away! :-)

Posted on Dec 15, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

4 Answers

How to recover Excel lost file


How to solve some troubles with excel files you may learn from- http://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/481-%E2%80%8Bexcel-files-corrupted

How to Recover an Excel File for Free

1.Check the Recycle Bin--if you've accidentally deleted the file, it should still be there unless you've emptied the bin, and you can click on the file and recover it.

2.Use the Auto Recovery Pane when you open Excel. Review the document recovery pane. If Excel has managed to recover your file, it will show in a separate pane on the left-hand side. Identify your document in the pane, then click on it and choose "Open" to open the recovered file.

3.Try manually repairing the file. Click on "File" in Excel 2003 or the "Office" button in
Excel 2007, then select "Open" and click on the arrow next to the "Open" button. Click on
"Open and Repair" and choose from two options: click on "Repair" if you want to try to completely recover the file, or click on "Extract Data" if you previously tried Step 1 and it did not work.

4.Search for the file manually on your computer. When performing a system search (click "Start" and select "Search" in Windows XP and Windows 2000, or press the "Windows" button and "F" key in Windows 7 and Vista), make sure you choose "Advanced Search Options" and then check the "System and hidden files" check box. You may be able to find your missing or corrupted file using this search: double-click on the file name in the search results to open it.

If nothing can help you, look at Excel Repair Toolbox

As a solution, it costs money, but effective- http://www.excelrepairtoolbox.com/

Nov 11, 2014 | Microsoft OFFICE 2013 PROFESSIONAL 1 PC...

1 Answer

How to delete a header/footer in excel 2010?


To remove the header or footer text from Excel 2010 worksheet, you can follow the instructions below:
1.Go to "Insert" tab and then go to "Text" section.
2.Click "Header and Footer"
3.Click the left, center, or right header or footer text box at the top or the bottom of your worksheet page.
(Note: Clicking any text box selects the header or footer and displays the "Header and Footer Tools", adding the "Design" tab.)
4.Press "Backspace" or "Delete" on your keyboard.
To know more about removing header and footer, you can refer to "Remove the header or footer text from a worksheet" section on the following Microsoft support page:
http://office.microsoft.com/en-in/excel-help/use-headers-and-footers-in-worksheet-printouts-HP010342991.aspx#BMremoveheaderfootertext

Hope this will help you.

GuruAid.com

Sep 03, 2014 | Microsoft Operating Systems

1 Answer

Remove page breaks in excel


We would appreciate if you share with us your Excel version as well so that we can give you a more specific solution to your issue. In the meanwhile, you can refer to the following steps to delete a manually-inserted page break in Excel 2007, Excel 2010, or Excel 2013:

(Important: You cannot delete page breaks that Excel has added automatically. Adding manual page breaks, changing the page orientation, or adjusting column widths and row heights may affect automatically-inserted page breaks.)

1. Select the worksheet that you want to modify.
2. Go to "View" tab, then go to "Workbook Views" section, and click "Page Break Preview".
(Note: You can also click "Page Break Preview " on the status bar)
(Important: If you get the "Welcome to Page Break Preview" dialog box, click "OK". To avoid seeing this dialog box every time you go to "Page Break Preview" view, select "Do not show this dialog again" check box and click "OK".)
3. Now do one of the following:
a) To delete a vertical page break, select the column to the right of the page break that you want to delete.
b) To delete a horizontal page break, select the row below the page break that you want to delete.
(Note: You cannot remove automatic page breaks)
4. Go to "Page Layout", then go to "Page Setup" section, and click "Breaks"
5. Click "Remove Page Breaks"
(Important: You can also remove a page break by dragging it outside of the page break preview area {to the left or right for vertical page breaks, or up or down for horizontal page breaks}. If you cannot drag page breaks, make sure that the drag-and-drop feature is enabled. To check the status of your drag-and-drop feature, click office button , click "Excel Options" tab, click "Advanced", go to "Editing Options" and make sure you have checked the "Enable fill handle and cell drag-and-drop" option.)

To refer to a pictorial explanation of the above steps, you can refer to "Delete a manually inserted page-break" section on the following Microsoft Support Page:
http://office.microsoft.com/en-in/excel-help/remove-a-page-break-HA102576899.aspx?CTT=1

GuruAid.com

Jun 22, 2014 | Operating Systems

1 Answer

What is the procedure to print ms excel worksheet


Get your Worksheet Copy ready in Microsoft Excel. Go to Option and click on Print (if you are using MS-Office 2010) or Click on Print Preview (if you are using MS-Office 2007) to get a preview of your copy ( i.e. what you are going to print just now). If you want to print it directly, press Ctrl+P to get started with printing your copy and click on Print option (for both Office 2007 & 2010).

Feb 02, 2011 | Microsoft Windows XP Professional for PC

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

Ms excel


In Excel Worksheet 2007 the maximum number of rows per worksheet is 1,048,576 and the no. of cols. is 16,384 which is col. XFD, which makes it 17,179,869,184 cells.

Jul 26, 2010 | Microsoft Windows Vista Ultimate Edition

1 Answer

I need to print mailing labels imported from excel to word in columnar order instead of in order by rows across the page.


hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

Dec 14, 2009 | Microsoft Windows XP Professional

5 Answers

Excel file corrupt how to recover


Better Stellar Phoenix Excel Recovery which can fix corrupt Excel (.XLS/.XLSX) files and restore everything (including charts, chartsheets, cell comments, worksheet properties etc.

Aug 20, 2009 | Microsoft Windows XP Home Edition with...

1 Answer

Excel Recovery


You have to search the file name in all drives.

Jan 31, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

Microsoft excel


I'm not sure what you mean exactly...

Do you want to sort an existing excel worksheet?
Or do you want to change a cell value depending on the class of students.
You can use if for the latter.
Otherwise just use sorting in excel.

Please explain what you want to do exactly...

May 24, 2008 | Microsoft Windows XP Professional

Not finding what you are looking for?
Microsoft Windows XP Professional Logo

Related Topics:

61 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Alex Krenvalk

Level 2 Expert

401 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...