0
What else can I help you with?
Excel provides the ability to create new worksheets and new what?
workbooks
Explode Excel worksheets into separate Excel workbooks?
If your Excel workbook has several worksheets and you want to save them into separate Excel workbooks, try the following: Position your mouse on the worksheet tab (bottom left of the screen). Right mouse click on the worksheet tab and select "Move or copy" from the shortcut menu. This opens the Move or Copy dialog box. In the "To book:" field, choose "(new book)"Click the check box for Create a copy if you want to keep the worksheet in the original workbook, or leave it unchecked if you want to move the worksheet from the original workbook. Click OK to finish the steps.
What does Excel default name a new workbook?
It normally calls it Book1, but if there were other new workbooks open already, then it could use Book2, Book3 etc.
Does Excel use default Oriel theme for all new workbooks?
No. There are lots of versions of Excel. They do not all use Oriental as a default theme.
What are some differences between Excel 2003 and Excel 2007?
The most obvious visible difference is the ribbon bar (new menu system) displayed by all Office 2007 products. You also will notice a new file format. Excel 2003 uses an extension of XLS, while Excel 2007 uses the extension of XLXS, You can open Excel 2003 files in Excel 2007, but not the other way around. Excel 2007 adds many new functions. See related links for what's new with Excel 2007. Also see the related links for how to match the old Excel 2003 menu items with the new Excel 2007 ribbon.
How you can covert a cvs file to xls file?
You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.You can open a CSV file directly with Excel. When you go to open it, look under All Files, so that you can see the file with a csv extension, and not just xls files. When you open it, it will read it into the worksheet, using the commas to mark where each new cell begins and each new line will be put into a new row.
How can you set a particular folder to select files from to create hyperlink in Excel?
To create a hyperlink to a new file in excel you need to click on the Insert Hyperlink dialog box. You will see a dialog box, that you will mark, that says existing file or web page.
If I changed my RAM would it affect my files?
No, changing your RAM will not affect your files. Your files are stored on your hard drive, which is a separate piece of hardware from the RAM. Once you shut down your system, your files are safely stored on the hard drive, so adding new RAM or replacing old RAM will have no effect on your files.
What is a special workbook or worksheet you can create and then use as a pattern to create new similar workbooks or worksheets?
A template.
What is the default save as type option and how many other options are available?
1: File location Many users don't use the default file folder, My Documents. You can quickly change this default and save workbooks where you want automatically, as follows: Click the File tab and choose Options (under Help). In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu. In the left pane, choose Save. In Excel 2003, click the General tab. In the Save Documents section, change the path in the Default File Location field, as shown in Figure A. You can type the path or click Browse to locate it. Click OK. Figure A Save files where you want, instead of in My Documents. 2: Number of sheets Each new workbook includes three sheets. You can add and delete sheets, but you can also change the number of default sheets, as follows: Click the File tab and then click Options (under Help). In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu. Click General in the left pane. In Excel 2003, click the General tab. In the When Creating New Workbooks section, enter the number of sheets in the Include This Many Sheets field, as shown in Figure B. In Excel 2003, use the Sheets In New Workbook drop-down. Click OK. Figure B Determine the number of sheets provided in a new workbook. 3: Open a specific workbook Opening a specific workbook when launching Excel can save a little time if you often work with the same workbook. This shortcut is easily accomplished by saving that workbook in the XLStart folder. Depending on your version of Windows, you'll find that folder in one of the following locations: Windows XP: C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart Windows Vista: C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart Windows 7: C:\Program Files\Microsoft Office\Office\XLStart Just save the workbook as you normally would, but save it to the appropriate XLStart folder. 4: Cursor movement When you press Enter, Excel moves the cursor down one cell. If you enter data by moving to the right, rather than down, you can change the cursor's behavior, as follows: Click the File tab and then click Options (under Help). In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu. In the left pane, select Advanced. In Excel 2003, click the Edit tab. In the Editing Options section, choose Right from the Direction drop-down under the After Pressing Enter, Move Selection option, as shown in Figure C. You can choose Right, Left, Up, and Down. In Excel 2003, the option is Move Selection After Enter. If you don't want the cursor to move at all, uncheck the option. Click OK. Figure C This option lets you control Excel's cursor behavior when pressing Enter. 5: Font face and size You might want to change the default font and size if your organization's conventions require something different. By doing so, you eliminate the task of adjusting each new workbook. To change the default font, do the following: Click the File tab and then click Options (under Help). In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu. Choose General (if necessary) from the left pane. In Excel 2003, click the General tab. In the When Creating New Workbooks section, change the Use This Font (Standard Font in Excel 2003) and Font Size options, as shown in Figure D. Click OK. Figure D Update these settings to specify the font and size of your choice in all workbooks. 6: Template Like Word, Excel bases each new workbook on a template file (Book.xltx). You can permanently change many default settings by adjusting Book.xltx. You can make this change once to Book.xltx, instead of adjusting each new workbook manually. When making changes at the template level, you can start in one of two ways: If you've customized Book.xltx, open it so you don't lose prior changes. If you haven't customized Book.xltx, you can begin with any blank workbook. Make the changes you want to implement at the template level and then save the workbook as a template: Click the File tab and choose Save As. In Excel 2007, click the Office button and choose Save As. In Excel 2003, choose Save As from the File menu. Choose Excel Template (.xltx) from the Save As Type drop-down, as shown in Figure E. Excel 2003's template extension is .xlt. Locate the XLStart folder using the Save In control. You must save Book.xltx to the XLStart folder. Click Save. Figure E Specify the file as a template, using the appropriate extension. If you can't find XLStart, you can use Excel's Visual Basic Editor to find the path, as follows: Launch Excel's VBE by pressing Alt + F11. If the Immediate window isn't visible, press Ctrl + G. In the Immediate window, type ? application.StartupPath and press Enter, as shown in Figure F. Figure F If you can open the VBE, you can find XLStart. If you want to alter things at the sheet level, make your changes and save the file as Sheet.xltx. You'll use this file to change things such as inhibiting gridlines. 7: Startup folder Tips #3 and #6 both rely on the XLStart folder to open or use specific files when you launch Excel. You can add a second location as follows: Click the File tab and then click Options (under Help). In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu. Choose Advanced in the left pane. In Excel 2003, click the General tab. In the General section, enter the path to the new alternate startup folder, as shown in Figure G. Click OK. Figure G Specify an alternate startup folder. Excel will continue to open any workbooks found in XLStart, in addition to those workbooks found in the alternate startup location. 8: File format Many organizations must deal with version compatibility issues because some users upgraded to the Ribbon version before others. When sharing Excel 2007 and 2010 files (.xlsx format) with Excel 2003 users, you must downgrade the workbook to the older format (.xls). Doing so is no big deal, but if you have to do it for every workbook, you might as well change the default file format to .xls, as follows: Click the File tab and choose Options (under Help). In Excel 2007, click the Office button and then click Excel Options. Choose Save in the left pane. In the Save Workbooks section, choose Excel 97-2003 Workbook (*.xls) from the Save Files In This Format drop-down, as shown in Figure H. Click OK. Figure H Save all files to the .xls format automatically. This solution is limited to workbooks that don't use new features. It might be easier to download the compatiability pack for those still using Excel 2003. 9: Enable text wrap When you enter a long string into a cell, Excel allows it to extend past the column's right border. If there's no data in the adjacent cells, the entire string is visible. But once you enter data in the adjacent cell, the new data takes precedent and the original string disappears behind the new text. This happens at the format level and you can reset this alignment attribute by adjusting the Normal style. Unfortunately, that doesn't help all the other workbooks you create. If this is a format you want to set for all new workbooks, change the Normal style in book.xltx (#6): Click the Home tab. Then, in the Styles group, click the Cell Styles drop-down. In Excel 2003, choose Style from the Format menu. In the resulting gallery, right-click Normal and choose Modify, as shown in Figure I. In Excel 2003, select Normal in the Style Name control, click Modify, and then skip to step 4. In the Style dialog, click Format. Click the Alignment tab and select the Wrap Text option in the Text Control section, shown in Figure J. Click OK twice. Figure I Modify the Normal style to set the Text Wrap property for the entire workbook. Figure J Selecting the Wrap Text option will allow text wrapping in all cells. Just remember that changing the Normal style works in the current workbook only. You must save this at the template level to adjust the style for all new workbooks. 10: Comment font size The font size for comments is easy to change, but it takes a detour from the traditional routes. You must change a Windows setting - you can't control the comment font size via Excel. If you're using Windows XP, do the following: Right-click the desktop and choose Properties. Click the Appearance tab and then click Advanced. From the Item drop-down, choose ToolTip. Select a font size and click OK. Click Apply and then click OK. Windows 7 users should do the following: Right-click the desktop and choose Personalize. Click Window Color. Click Advanced Appearance Settings. From the Item drop-down, choose ToolTip. Choose a font size. Click OK and then click Save Changes. This change will update all tip-type windows, not just Excel comments. So be sure you can live with the total package, especially if you share your system with other users. Note: Although the dialog will let you specify a different font, Excel will ignore the new setting. - Susan Sales Harkins is an IT consultant, specializing in desktop solutions.-
Can a file with a csv extension can ONLY be used by Excel?
CSV is a Comma Separated Variable file. These are simple text files with data in lines and text separated by commas. They are used as ways of storing data so it can be imported from one application to another. A CSV file could be created in Excel and then opened in a database such as Access. Each line would be a record and where each comma would be it would start a new field. Coming from Excel, each comma would have been created from the division of each cell, so data could be taken from Access, put into a CSV format and transferred to Excel and many applications. So CSV files are not limited to Excel.
What are three new highlights in Excel 2003?
MS Excel 2003 has been around for about eight years and has no new highlights.
