Viewing: Excel 2007

How to increase number of worksheets Excel

Microsoft Excel by default contains 3 worksheets while creating a new Workbook. For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain. This can be modified using Excel Options. Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013, Excel 2010 […] Read More

A trick to flip a column upside down in Excel

Excel users can sort a column using the Sort feature available as part of Sort & Filter menu. But what if you want to flip a column upside down. Let us see this with an example column having some text values as shown below.We will not be able to apply sort feature directly on this […] Read More

How to clear content only in Excel

Microsoft Excel provides users with various formatting option such as Number, Currency, Date and time that can be applied to a cell. But if you have a scenario where you want to only clear the content of the excel sheet and to preserve the format applied to the cells then you can use Clear Contents […] Read More

How to insert to current date and time in Excel

In Excel , you can insert date and time using different formulas. Listed below are the steps to insert date, date and time and time in Excel 2016, 2013, Excel 2010 and Excel 2007Navigate to the cell where you want to insert time and and press Ctrl + Shift + : keysAlso See: Disable conversion […] Read More

How to disable auto fill feature in Excel

Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill […] Read More

How to create a link between two worksheets in Excel

In this short beginners tutorial let us see the steps for creating a simple link between two worksheets in Excel 2016, 2013 and 2010. In Excel, two worksheets can be linked using the paste options.1. From Sheet1, Copy the cell value which needs to be linked with the other Sheet. This can be done by […] Read More

VLOOKUP function in Mircrosoft Excel explained with an example

VLOOKUP in Excel can be used to automatically populate values from a given list based for specified identifier. For example you can use VLOOKUP to pre-populate employee code based on employee name. Let us take the following example where the employee list (name, code) is defined in the range A2:B6 Now we can use VLOOKUP […] Read More

Change display of recent documents/workbooks in Excel

Microsoft Excel has a feature that allows users to change the number of recent workbooks or documents shown in the Open screen. Listed below are the steps to increase or decrease the recent documents in Excel 2013, Excel 2010 and Excel 2007 Recent documents or workbooks in Excel 2013 and Excel 2010 The default value […] Read More

How to change the installed user name in Microsoft Excel

Microsoft Excel by default takes the installed user's name as the owner of the installed version. You can personalize the username to your desired name using the Excel options. This is the same username that appears when you add a comment in Excel worksheet. Listed below are the the steps to be followed to update […] Read More

Disable conversion of two numbers with hyphen as date in Excel

Microsoft Excel has a feature that automatically coverts two numbers separated by hyphen in to a date formatted value. For example if you type 6-7 in a cell, Excel would reformat this in to a date value as 7-Jun. But if you do not want to reformat then you can use any of the below […] Read More

Tables and Borders in Microsoft Office 2007

'Tables and Borders' is a very useful styling property in Microsoft Office 2007. Using this, you can create a new table and style it to best suit to your document. Here I will discuss some of the useful aspects of Tables and Borders which is necessary in almost every Office environment, even in Excel. How […] Read More

How to turn on or off Auto fill feature in Excel 2007

Auto fill in excel is quite handy feature. Using this you can fill series of cells based on the entries of other excel cells. This feature can be turned on or off using the Excel Advanced Options. Click on the Office button –> Excel Options Under Excel Options select Advanced section By checking or un […] Read More

How to change Excel 2007 comment colour in Windows Vista

Microsoft Excel 2007 allow users to add comments. If you want to change the comment colour in Excel 2007 to your preferred choice then you can follow the following steps 1. Right click on the Desktop properties and select Personalize option 2.  In the Personalization window, click on the Window colour and Appearance link. 3.  […] Read More

How to change the default font for Excel 2007 Workbook

Microsoft Excel 2007 default font can be changes using the Excel Options. The default font in Excel 2007 is Calibri and if you want to use a different font for new workbooks then click on the Office button followed by Excel Options button. This would display the below excel options window. Under Popular tab, "When […] Read More

How to create a password protected Microsoft Excel 2007 Spreadsheet

Microsoft Excel 2007 provides an option for creating password protected spreadsheets. This can be done by clicking on File --> Save As. This would display the following Save As dialog box   Now click on the Tools drop down displayed at the bottom of the dialog box and select General Options from the drop down. […] Read More

Get your free copies of the following tech guides by joining the Digital Answers mailing list.