0 Comments

What is Page Break Preview in Excel 2019?

What is Page Break Preview in Excel 2019, 2016, 2013, 2010, and 2007? What is Page Break Preview in Excel 2019?: Page Break Preview shows the worksheet by separating it as pages that contain contents which are to be printed. Before going to take printout the worksheet area, you may check out in which part […]

0 Comments

Mathematical Operators in Paste Special in Microsoft Excel

The Mathematical Operators in a Paste special is a feature, used to paste the copied contents in a specific format. Besides this, you can use keyboard shortcuts to perform mathematical operators such as add, multiply, subtract, or divide a specific number to the selected range of cells in a worksheet. STEP-1 Prepare the data table in which you want to add, […]

0 Comments

How to Copy the Text as a Picture in Microsoft Excel

How to Copy the Text as a Picture in Microsoft Excel : This command is a great way to copy the content as shown on the screen or as shown when printed in a Bitmap or Picture Format. And you can paste it wherever you want in the Microsoft Office Excel, Word document or other […]

0 Comments

How to Wrap Text in Excel Spreadsheet 2019, 2016, 2013, 2010, and 2007

How to Wrap Text in Excel Spreadsheet: When you enter the extra-long text more than the width of a cell in a worksheet, the remaining part of the text appears in the next cell. In this case, you can’t see entire text when you type the text in next cell. Here you can adjust the […]

0 Comments

Paste Special Feature Shortcuts in Excel 2019, 2016, 2013, 2010 and 2007

Paste Special Feature Shortcuts in Excel: The Paste special is a feature, used to paste the copied contents in a specific format. Using this feature, you can paste several formats like formulas, values, formats, comments, data validation, number formats. Also, you can add, multiply, subtract, or divide a specific number to the selected range of […]

2 Comments

Introduction to Microsoft Excel Spreadsheet Environment

Introduction to Microsoft Excel Spreadsheet Environment Introduction and user interface to Microsoft Excel Spreadsheet: Excel is an electronic spreadsheet program, developed by Microsoft Corporation.  An Excel Spreadsheet is used to record, validate and analyze the numeric data for maintaining Payrolls, Selling and purchasing of product orders, Progress Reports, family budgets, and more. These are calculated […]

0 Comments

6-Ways to Insert New Worksheet In MS-Excel

6-Ways to Insert New Worksheet In Excel: 6-Ways to Insert New Worksheet In MS-Excel: In excel spreadsheet, there are several options are there to insert the “New Worksheet”. These are whether Keyboard shortcut or other options from the ribbon. in this article, 6 different ways are provided below to insert new worksheet in excel. Method-1: Click the New Sheet […]

0 Comments

Change Worksheet Tab Color in 4-Ways in MS-Excel

Change Worksheet Tab Color in 4-Ways: There are several ways to change the worksheet tab color by using the shortcut keys or other commands in excel. So, do one of the following methods. Method-1 Right click on the “Sheet tab”, which appears at the bottom right corner of the excel workbook as given in the […]

0 Comments

4-Ways to Rename a Worksheet in MS-Excel

4-Ways to Rename a Worksheet: 4-Ways to Rename a Worksheet: There are several ways to Rename a worksheet by using the shortcut keys or other commands in excel. So do one of the following methods. Method-1: Double-click the Sheet tab, and then type the name you want Method-2: Right click on the Sheet tab that you want to rename […]

0 Comments

6-Ways to Duplicate a Worksheet in MS-Excel:

6-Ways to Duplicate a Worksheet in MS-Excel: 6-Ways to Duplicate a Worksheet: There are several ways to duplicate the worksheet in excel using the shortcut keys or other commands in excel. So, learn all of the following methods. Method-1; Duplicate a Worksheet: Click and hold down the left mouse button on any sheet tab, then also […]

0 Comments

Applying Borders to the Cells in MS-Excel

Applying Borders to the Cells in MS-Excel: Before applying borders to the cells in MS-Excel, you can select the Line Color or Line Style or Both you want for different border format, or otherwise, leave it as it is if you wish to apply the default Line styles and Colors. To do it, follow the […]

0 Comments

Row Height and Column Width in Excel (Set in Several Ways):

Change Row Height and Column Width in Excel: Row Height and Column Width in Excel: There are several ways to expand the Row Height and Column Width in Excel. By default, the size of a Row Height is 15.00 points whereas the column Width is 8.43 points. However, we can expand the maximum height of […]

0 Comments

Merge and Unmerge Cells in MS-Excel

Merge and Unmerge Cells in MS-Excel: Combining more cells into one cell is called Merge cell. Similarly, dividing a cell into multiple cells which are merged, called Unmerge Cells.  1. Merge & Centre: Combining more cells into one cell and centering the text is called the Merge & Centre. Go to the Home tab Select the range of […]

0 Comments

Clear Formats, Contents, Comments and Hyperlinks in Excel

Clear Formats, Contents, Comments and Hyperlinks in Excel: Clear Formats, Contents, Comments, and Hyperlinks in Excel:  These commands are very useful to remove everything like Formats, Contents, Comments or Hyperlinks from the selection in a worksheet. To do so follow the steps given below: 1. Clear All Formats, Contents, Comments and Hyperlinks. To clear all […]

0 Comments

Freeze Panes in MS-Excel 2019, 2016, 2013, 2010, and 2007

Freeze Panes in MS-Excel: Freeze the Upper or Left or both part of the Row and Column Headings to keep it visible while the rest of the worksheet scrolls up and down or left and right. Also, you can unfreeze the panes after freezing the panes. Freeze Panes: Freeze upper and left part of the rows […]

0 Comments

How to use the Minimum and Maximum Functions in Excel

Minimum and maximum functions are used to return the smallest and highest values from the selected cells or in a range. Minimum: Returns the smallest value from the selected cells or in a range of cells. Syntax: =min( number1, number2, number3,….) (or) =min(first cell reference : last cell reference) Ex: =min(b1:c6) Follow the steps below […]

0 Comments

What is the Difference Between Functions and Formulas in Excel?

S.NO. Function Formula 1.        It is a Pre-defined/Built-in operation It is a user defined operation 2.        A function can be a formula A formula can be a function 3.        Ex: =sum(b2:d4) Ex: =20+30+5-3 4.        Functions can be updated by the developer. Formulas are like general calculations, so it can’t be. 5.      […]

0 Comments

View and Print Gridlines and Headings in Sheet Options-Excel

Gridlines View in Excel: The Gridline View helps you see or remove the gridline in excel when you check or uncheck the option. To do that, follow the steps below: Go to the Layout tab Click on the View in the sheet options group to Check or Uncheck it for view or remove the gridlines […]