Microsoft Excel is the most widely used spreadsheet program in the world and every professional who has to deal in numbers should be able to operate Excel. While Excel is very advanced, Microsoft has made it very easy for beginners to get started. Yesterday I was working with an Excel workbook where I had to […]
Microsoft Excel creates and opens three work sheets by default when you open an Excel workbook. For some people these three sheets are enough while others are used to working with a lot of sheets within Excel workbook. I like to work with only one work sheet per workbook. So I only want to open […]
In Microsoft excel 2010 name of default worksheet are Shee1, Sheet2, Sheet3, which is not appropriate to present and also its difficult to remember what that particular sheet contains, so Microsoft excel 2010 gives you option to rename the sheet as you want, but you should know that name cannot exceed 31 characters, as it’s […]
There may be certain instances when you have some sensitive information in your workbook and you want only appropriate or authorize person should see them, it means you need password to keep your workbook safe, this is how it can be done.
As I told in my previous articles that by default Microsoft Excel 2010 has three worksheets, some time we need more sheet, and some time these sheet are more than our need so we should know how to insert new sheet and how to delete the sheet as well.
When you are working on multiple Microsoft excel 2010 workbook, it difficult to switch between workbooks, rather it’s more appropriate to say it’s difficult to compare, or read both workbooks because you need to switch between them. Microsoft excel 2010 gives the option to view both workbooks together without switching between them, view the diagram […]
There are many reasons when you want to copy or move or copy your Microsoft excel 2010 worksheet within or to another workbook. This is how it can be done.
In Microsoft excel 2010 different worksheet can be represent with different colors, as I color my worksheet on the base of type of data they contains, so you can color your worksheet in Microsoft excel 2010 according to your criteria.
As I explained in previous article switching between Microsoft excel 2010 workbook you also need to switch between work sheets, there are also two methods to switch between work sheet, first method is
When editing or reviewing on Microsoft excel 2010, it’s almost necessary that more than one Microsoft excel 2010 workbook is open on our desktop, and we need to switch between Microsoft excel 2010 workbooks. There are many ways to switch between Microsoft excel 2010 workbook