Align Objects | Distribute Objects in Word, Ppt, & Excel

Align Objects | Distribute Objects in Word, Ppt, & Excel Manually aligning object is a time-consuming process. But Word, Ppt, Excel has a great feature to align any object, such as a picture, shape, textbox, 3D Models, Icons, etc. with a click. Besides this, you can also easily distribute more objects horizontally or vertically. Important […]

Read More »

Magical Shortcut Keys and Hidden Secrets in MS-Word 2019

Magical Shortcut Keys and Hidden Secrets Magical Shortcut Keys  and Hidden Secrets: There are many secrets, features and magics that are kept in MS Word. These tips and tricks in word help you make your document work faster and easier. So, there is no doubt that you don’t know all these secrets. I challenge you. You […]

Read More »

30 Ways to Select Text in MS-Word & Excel

30 Ways to Select Text in MS-Word 30 Ways to Select Text in MS-Word : There are several selection techniques are provided in MS-Word. These selection techniques includes Shortcut Keys, Mouse, and other Commands to select all the text, paragraph, line, word, character, any block and vertical selection. To learn all these tips and tricks, you should read […]

Read More »

Difference Between Functions and Formulas in Excel-21’s Big

Introduction to the “Difference Between Functions and Formulas in MS-Excel”: The function is a pre-defined operation that means it already exists and were developed by Microsoft Corporation as a part of an Excel Application. Whereas Formula is a user-defined operation that means it is like a general calculation doing by the wish of the user.  […]

Read More »

Freeze Panes in MS-Excel 2021’s Secret – Must Read

Freeze Panes in MS-Excel – Freeze Rows and Columns in MS-Excel Freeze Panes in MS-Excel: Freeze the Upper, 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, called Freeze Panes. Remove freezing the rows, columns or both […]

Read More »

Conditional Formatting in MS-Excel 2019 | New & Advanced

Conditional Formatting In MS-Excel Conditional Formatting in MS-Excel is one of the best features to format or highlight cells (with different colors) that contain data. This feature will help us easily spot certain cells with data based on the condition we have given. The data in the cells may include Less than any number, Greater […]

Read More »

Always Open Read Only in MS-Word, Excel, Ppt 2019

Always Open Read Only in MS-Word Always Open Read Only in MS-Word, Excel, Ppt: To prevent accidental changes from someone, you can enable “Always Open Read-Only” command. This process is only for an informational purpose but, it doesn’t protect your file. The changes are depending upon the readers. When you enable it, your file will […]

Read More »

Encrypt a Word Document or Excel Workbook with Password-20

How to Delete a Blank Page in Microsoft Word 2020 SecretMagical Shortcut Keys and Hidden Secrets in MS-Word 2019Conditional Formatting in MS-Excel 2019 | New & AdvancedBold, Italic, and Underline in MS-Word 2019, 2016…2007Different Watermark for Different Pages in Word 2019 | New Encrypt a Word Document or Excel Workbook with Password Encrypt a word […]

Read More »

What is Synchronous Scrolling in MS-Word & Excel?_Trick-1

What is Synchronous Scrolling in MS-Word & Excel: Synchronous scrolling is one of the great features, used to compare contents of two documents at the same time by scrolling one of the two documents. To use this feature, follow the steps below. Synchronous Scrolling in MS-Word: Open or create two excel worksheets that you want […]

Read More »

How to Select Text Vertically in MS-Word_No:1 Trick

Different Watermark for Different Pages in Word 2019 | NewBold, Italic, and Underline in MS-Word 2019, 2016…2007Conditional Formatting in MS-Excel 2019 | New & AdvancedMagical Shortcut Keys and Hidden Secrets in MS-Word 2019How to Delete a Blank Page in Microsoft Word 2020 Secret How to Select Text Vertically in MS-Word: This article provides you a […]

Read More »

How to Recover Unsaved Word Document, Workbook & Ppt 2019

Recover Unsaved Word Document, Workbook & Ppt. Recover Unsaved Word Document, Workbook & Ppt. in MS-Office: Did you lose your document or workbook which you not saved? So, don’t worry, here is a solution to Manage all your unsaved document or excel workbook by recovering necessary or deleting unnecessary files. To do so get started […]

Read More »

Create a Custom AutoFill Series List in Excel 20 | Excellent

Conditional Formatting in MS-Excel 2019 | New & AdvancedMagical Shortcut Keys and Hidden Secrets in MS-Word 2019Difference Between Functions and Formulas in Excel 20 MasterPaste Special in Excel & Word with No.1 Shortcuts ​Freeze Panes in MS-Excel 2020’s Secret – Must Read Create Custom AutoFill Series List in Excel Create Custom AutoFill Series List in […]

Read More »

What is Page Break Preview in Excel 2019?

What is Page Break Preview in Microsoft 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 of the worksheet is to be printed by dividing the number of […]

Read More »

How to Copy Text as Picture in Microsoft Excel

How to Copy Text as Picture in Microsoft Excel How to Copy Text as 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 […]

Read More »

Paste Special in Excel & Word with No.1 Shortcuts ​

Paste Special in Excel & Word with No.1 Shortcuts Paste Special Feature in MS 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 […]

Read More »

Introduction to MS Excel & User Interface to MS Excel

Introduction to MS Excel Introduction to MS & User Interface to Excel: 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 whether using […]

Read More »

6-Ways to Insert New Worksheet In Microsoft 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 […]

Read More »

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

Change Worksheet Tab Color in 5-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 to Change Worksheet Tab Color in Excel Right click on the “Sheet tab”, which appears at the bottom right corner of […]

Read More »

Quick Access Toolbar in MS-Word 2019 | Imaginative

Quick Access Toolbar in MS-Word Customize Quick Access Toolbar in Microsoft Office Word:  Do you wanna use the commands of the word quickly and frequently so, customize the quick access toolbar by adding or removing the commands? The Quick Access Toolbar locates at the top left corner on the title bar. By default, the Quick Access Toolbar […]

Read More »

Hidden Control Buttons in MS-Word 2019

Hidden Control Buttons in MS-Word Hidden Control Buttons in MS-Word: The Hidden Control Buttons are contextual, that appears based upon the Left or Right click on the Title bar. There is a slight difference between the Hidden Control Buttons and the Control Buttons. In general, the control buttons include Minimize, Restore Down/Maximize and Close, appear at the top right corner of the MS Office […]

Read More »

File Menu Options in Microsoft Word, Excel & Ppt 2019-2013

File Menu Options in MS-Word File Menu Options in MS-Word: The File menu controls and accesses the file functions of the MS-Office Products. Formally, a file menu handles the files by using various commands. The list of file menu commands is info, New, Open, Save, Save as, Print, Share, Export, Account, Share, options, and Close. What is an […]

Read More »

Change Color Themes in Microsoft Office 2020 Master

Change Color Themes in Microsoft Office Products: Change Color Themes in Microsoft Office: To change the Office Color Themes in Word, Excel, PPT or Other Office Applications, follow the steps below: Go to the “File” menu in one of the office applications. For example, MS-Word Then select the “Account” After that, click the drop-down arrow of the Office Theme Under […]

Read More »

Page Setup in MS Word, Excel, PPt 2019, 2016…2007-Big

Page Setup in MS-Word, Excel, PPt. Page Setup in MS-Word includes: Page Margin is the space between contents and edges of each side of the document.  Orientation is the page layout, in which the document is displayed or printed. The common types of page orientations are Portrait and Landscape. Page size is choosing different paper […]

Read More »

Wrap Text in Microsoft Word and Excel 2020 Master

Wrap Text in MS Word and Excel In word processing, wrap text around an object or text wrapping means to arrange the object in line with text, tight text, square text, behind text, in-front text, edit wrap points, etc. On the Layout tab, in the Arranges group, the default arrangement of the objects are in line […]

Read More »

4-Ways to Rename a Worksheet in MS-Excel

4-Ways to Rename a Worksheet in MS-Excel 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 to Rename a Worksheet in MS-Excel: Double-click the Sheet tab, and then type the name you want. 4 Ways […]

Read More »

6-Ways to Duplicate a Worksheet in MS-Excel

6-Ways to Copy a Worksheet in MS-Excel: 6-Ways to Copy or 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: Copy or Duplicate One Worksheet by Copying: Right click on any “Sheet tab” Then click […]

Read More »

Apply Borders to the Cells in MS-Excel

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

Read More »

Merge and Unmerge Cells in MS-Excel

Merge and Unmerge Cells in MS-Excel Merge and Unmerge Cells: Combining more cells into one cell is called Merge cell. Similarly, dividing a cell into multiple cells which are merged, called Unmerge Cells. The lesson on Merging and Unmerging Cells is discussed below. Merge and Unmerge Cells in Excel 1. Merge & Center: Combining more cells […]

Read More »

Clear Formats, Contents, Comments and Hyperlinks in Excel

Clear Formats, Contents, Comments and Hyperlinks Clear Formats: Used to remove each and every format like, color, size, and other from the selection in a worksheet. Clear All: Used to remove all content and formats in a Excel Worksheet. Clear Contents: Only removes contents in a Worksheet Clear Comments: Removes comment in a Worksheet. Clear Hyperlinks: […]

Read More »

View and Print Gridlines and Headings in Sheet Options-Excel

View and Print Gridlines and Headings in Sheet Options-Excel In this article, you can learn how to View and Print Gridlines and Headings in Excel. These options are especially useful when you print the worksheet using whether the gridlines and headings or not. View and Print Gridlines and Headings in Excel​ View Gridlines in Excel: […]

Read More »

View and Print Gridlines and Headings in Sheet Options-Excel

In this article, you can learn how to View and Print Gridlines and Headings in Excel. These options are especially useful when you print the worksheet using whether the gridlines and headings or not. 

View and Print Gridlines and Headings in Sheet Options-Excel
View and Print Gridlines and Headings in Excel​

View Gridlines in Excel:

View Gridline helps you see or remove the gridline in excel when you check or uncheck the option. To do that, follow the steps below:

  1. Go to the Layout tab
  2. Click on the View in the sheet options group to Check or Uncheck it for view or remove the gridlines of a worksheet.

Print Gridlines in Excel:

 Print  Gridlines option helps you print or no print the gridline in excel when you check or uncheck the option. To do that, follow the steps below:

  1. Go to the Layout tab
  2. Click on the Print under gridlines in the Sheet Options group to Check or Uncheck it for print or no print the gridline of a worksheet.
  3. To see the print preview after the check or uncheck the gridline print option, click the print pane option
  4. Then click on the Print Preview.

View Headings in MS-Excel:

View Gridline option helps you see or remove the gridline in excel when you check or uncheck this option. To do that, follow the steps below:

  1. Go to the Layout tab
  2. Click on the View in the sheet options group to Check or Uncheck it for view or remove the Headings of a worksheet.

Print Headings in MS-Excel:

Print Headings option helps you print or no print the Headings in excel when you check or uncheck this option. To do that, follow the steps below:

  1. Go to the Layout tab
  2. Click on the Print under Heading in the Sheet options group to Check or Uncheck it for print or no print the gridline of a worksheet.
  3. To see the print preview after the check or uncheck the Heading print option, click the print pane option
  4. Then click on the Print Preview.

Other Related Posts: