0
What else can I help you with?
When you open an Excel workbook how many sheets by default does a workbook have?
It depends what version you are using. Excel 2013 only has one worksheet by default, but earlier versions had three. Note that you can change the number of sheets when creating a new workbook via Excel options.
How many worksheets does Excel have when it opens a new workbook?
In Microsoft Excel, a new workbook will normally have three worksheets.
How do I link an Excel spreadsheet item to a paragraph in a Word document?
You can use a hyperlink to link from a Word document to an Excel document. Select the text you want to act as the link and press Ctrl-K. You can then find the excel workbook you want to link to. You can also copy from an Excel document and paste as a hyperlink, using Paste As Hyperlink in the Word document. This can link to a specific point in the Excel Workbook. You can also do a Paste Link to maintain a connection between the two files, so that when there are changes in the Excel workbook, they will be seen in the Word document.
When Excel starts it creates a new empty called Book1 which is like a notebook?
An Excel spreadsheet is called a workbook. Each individual page is called a worksheet.
Can an excel workbook be published as an HTML and be saved on web page?
Yes, an Excel workbook can be published as HTML and saved on a web page. You can use Excel's "Save As" feature to export the workbook in HTML format. Once saved, the HTML file can be uploaded to a web server, allowing users to access it through a web browser. Additionally, it’s also possible to embed Excel workbooks using online services like Microsoft OneDrive or Google Sheets for interactive features.
What is the file extension that indicates an Excel file?
Excel 2003: .xls = Workbook .xla = VBA Add-in .xlb = Toolbar (where custom toolbar settings are stored) .xlc = Chart .xld = Dialog (from older versions of Excel) .xlk = Archive (Excel spreadsheet backup) .xll = DLL Add-in .xlm = Macro .xlt = Template .xlv = VBA Module .xlw = Workspace (collection of multiple Workbooks) Excel 2007 and Excel 2010: .xlsx = Workbook (XML format) .xlsm = Macro-enabled Workbook .xlsb = Excel Binary Workbook (instead of XML format) .xltm = Macro-enabled Template .xlam = Add-in (XML format)
If two Microsoft Excel sheets are opened together then how can I close one of the windows of the Excel sheet with the keyboard i.e. without using the mouse?
Depending on if you have them open in separate windows of Excel.If they are in the same window: * Ctrl + F4 = Closes the active workbook. If they're in separate windows: * Alt + Tab = Changes your active window * Ctrl +F4 = Closes the active workbook. OR * Alt + F4 = Closes Excel; closes the program. * Ctrl + W = Also closes the active workbook (It doesn't matter if you have extra sheets in Microsoft Excel, unless if someone tells you it does matter.)
To reopen a workbook once Excel is opened you can check what from the office menu?
When an Excel file goes haywire, don't give up hope. Using one of these recovery tricks, you may still be able to salvage the data.Even if you faithfully back up your Excel workbooks, corruption can still be a problem. The backup files won't always contain your most recent work, so you'll probably end up re-entering data. Repairing a corrupted workbook, if possible, is a better option. In this respect, Excel can help. If you attempt to open a corrupted workbook, Excel will engage File Recovery mode, which attempts to repair the workbook. If that works, great! Unfortunately, Excel's automated File Recovery feature sometimes fails to repair a damaged workbook. When this happens, you'll need alternatives. Try the easiest solutions first. The more complex methods usually recover data, but no formulas, formatting, charts, or macros.Note: This article is also available as a PDF download.
What does Excel save it's information to?
It saves a workbook in the specified format to the specified folder. So normally it saves in the standard Excel format for the version you are using and saves the file in the My Documents folder, or whichever folder you select.
Can you convert an Excel 2003 spreadsheet to 2010 to add more rows?
If you have 2010, then you can open it and save it as a 2010 workbook. It won't open with Excel 2003 after that though so you cannot have the benefit of the extra rows in Excel 2003. That is one of the reasons for using 2007 or 2010.
How do you change Excel file into xml file?
By default Excel should save files in the .xml or .xmlx format (the latter being the default format for Excel 2007 & 2010). Other common formats that Excel accepts include .cvs and .txt. If you have that (or any other format) this is the easiest way to change the format:Open the file in Excel. Select "Save As" from the tile menu/office button (depending on your version of Excel). When you're prompted to select a location and file name, change the file type (using the drop down menu at the bottom of the screen) to Excel workbook (if you're using a version older than 2007) or Excel 97 - 2003 workbook (if you using 2007 or newer).There other methods, but they require slightly higher degrees of technical proficiency than this one.
When you save a document in Excel what does it save as?
It will save it with the name you specify and as the default type of workbook for the version of Excel you have. You should give the file a name, but if you don't it will call it Book1 and then add the appropriate extension. For the more modern versions, which is Excel 2007 onwards, that would be .xlsx, but if you are using an older version than Excel 2007, then it would be .xls instead.
