6-Ways to Copy or Duplicate a Worksheet in MS-Excel:
6-Ways to Copy or Duplicate 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” […]
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 […]
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 […]
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. The lesson on Merging and Unmerging Cells is discussed below. 1. Merge & Centre: Combining more cells into one cell and centering the text is called the […]
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 […]
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 that contain numbers. Minimum: Returns the smallest value from the selected cells or in a range of cells that contain numbers. Syntax: =min( number1, number2, number3,….) (or) =min(first cell reference : last cell reference) […]
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 […]
Units of Memory Measurement in Computer
Units of Memory Measurement in Computer/Data Storage Measurement in Computer Units of Memory Measurement in Computer (Data Storage measurement in computer) are Binary digit, Byte, Kilobyte, Megabyte, Gigabyte, Terabyte, etc. The smallest and most commonly measured units of data storage capacity in computers and other discs are the bit (short for binary digit). The binary […]
Add, Rename, Collapse and Expand Section in Powerpoint
Add, Rename, Collapse and Expand Section in Power point: Add section to the set of slides which are related to the specific category, message, theme or item to organize them in a sequence. Add Section: To add section for your slides wherever you want to start, follow the steps below. Note: You can add section […]
Change the Mouse Pointer/ Cursor on Windows OS
How to Change the Mouse Pointer/Cursor and Color on Windows OS: In Windows Operating systems, you can change the mouse cursor to a different size with black and white color without using 3rd party software. Let’s see how. Let’s see how to change the mouse pointer/mouse cursor on Windows 10 follow the steps below. Right […]
Permanent and temporary deletion of files, folders, & other icons
Permanent and temporary deletion of files, folders, & other icons: The following article describes how to delete file, folder and other icons along with shortcuts. Follow the steps below the picture to get started. How to permanently delete a file or folder | How to temporarily delete a file or folder Temporary deletion of the […]
How to Point Your Domain to Hosting or Server in 2 Best ways
How to Point Your Domain to Hosting or Server in 2 ways: There are two ways to point your domain to your hosting service. 1. Pointing with the IP address of your hosting service provider. 2. Pointing with nameservers of your hosting service provider. Method-1 Point Your Domain Using “A” record: Firstly, log in to […]
Creating Styles in MS-Word: No.1 Tricks
Creating Heading Styles in MS-Word: No.1 Tricks Creating Heading & Other Styles in MS-Word: Quickly apply different formatting styles to your content of the document by using the built-in styles such as Headings, Titles, Subtitle, Quotations, and Indentions, and so on. If an existing (built-in) styles are not suitable to your document content, you can […]
How to Translate One Language to Another | No.1 Trick
When a language doesn’t make sense to us, we look for the dictionary. But to know the word meanings of a language in a paper dictionary takes some time, and we can’t take dictionaries everywhere. But there are many easy ways out of this. The meaning is to translate any word online which are not […]