4G Accounts
Its All About Knowledge
  • Home
  • Accounting & Finance
  • Education
  • Microsoft Excel
  • General
  • Privacy Policy
112811_0640_HowToChange1.png

How To Change The No. of Sheets Opened By Default In An Excel Workbook

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 […]

100911_1242_RenameWorks1.png

Rename Worksheet in Microsoft Excel 2010

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 […]

100911_1241_Protectwork1.png

Protect workbook in Microsoft Excel 2010

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.

100911_1241_InsertandDe1[1]

Insert and Delete worksheet in Microsoft Excel 2010

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.

100911_1241_Howtoviewmu1.png

How to view multiple workbook in Microsoft excel 2010

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 […]

100911_1240_Copyormovew1.png

Copy or move worksheets within or to another Workbook in Microsoft Excel 2010

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.

100911_1240_Coloryourta1.png

Color your tab in Microsoft Excel 2010

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.

100711_1239_Navigatebet1.png

Navigate between Microsoft Excel 2010 Work Sheets

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

100611_1819_Switchingbe1.png

Switching between Microsoft excel 2010 workbook

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

100511_0758_UsingSaveSa1.png

Using Save & Save As command in Microsoft Excel 2010

While working in Microsoft Excel 2010 one thing you should remember that you should keep on saving your work, maybe you know that Microsoft Excel 2010 auto save you work after every few min, so if your system get shutdown you will only lost your few minutes workings.

< 1 2 3 4 5 >»

Newsletter

Recent Posts

  • 3890B565CDetailed Excel Keyboard Shortcut Cheatsheets
  • print-1Customize your Excel Sheets for Printing
  • Increment cell values in excel5 Ways to Increment the Cell Values in Excel
  • func-vlookup6 Ways to Search Data in Excel
  • DAverage Function in Excel 2013Handy Database Functions in Excel 2013

↑

© 4G Accounts 2023