Miscellaneous Articles: Excel and Google Sheets

All resources related to Miscellaneous for Excel and Google Sheets.
All articles Miscellaneous

Miscellaneous

How to Switch Between Tabs in Excel – Excelchat
An Excel Workbook may contain multiple sheets or tabs and while working on different parts of data we need to quickly switch between tabs in excel. Using the shortcut to switch tabs is a more effective way instead of switching the sheets by clicking on the right and left arrow....
How to Select Multiple Cells in Excel – Excelchat
When we need to apply certain formatting style, copy a range of data, select different ranges of data to insert Excel Charts, then selecting multiple cells becomes vital. We can select a range of cells, adjacent and nonadjacent, specific cells, multiple rows and columns using different techniques. Figure 1. Selecting...
How to Compress Excel File – Excelchat
When we keep on adding data, formulas, images to the worksheets, the size of the file increases and it makes the file slow to respond and difficult to send it to others. We can compress file to reduce its size using the various techniques. Figure 1. Compressing Files How to...
How to Insert Excel Spreadsheet into Powerpoint – Excelchat
In powerpoint presentation, if we need to show the data in the spreadsheet then we need to close or minimize our powerpoint and switch to the spreadsheet. But we can insert excel data into powerpoint to show spreadsheet without exiting powerpoint presentation. Figure 1. Inserting Excel File Into Powerpoint How...
How to Insert a New Worksheet in Excel – Excelchat
A workbook may contain multiple worksheets to add various data sets in the current workbook. We can easily insert new worksheet in a workbook when we want to maintain a separate set of data like Products, Customers or Sales by months, etc. There are different ways to insert a new...
How to Link Cell to Worksheet in Excel – Excelchat
We can quickly navigate to different worksheets of the same workbook by linking worksheets with specific cells of a sheet. To link a cell to a worksheet we add a hyperlink between the content of a cell to the cell reference of another worksheet. In this way, we quickly jump...
How to Make a Heat Map in Excel – Excelchat
Heat map is a graphical representation of data on a color scale. It gives us a comparative view to understand the pattern in the data set. We create a heatmap with conditional formatting using built-in color scale rules. Figure 1. Heat Map How to Make a Heat Map Suppose we...
How to Make a Heat Map in Excel
Heat map is a graphical representation of data on a color scale. It gives us a comparative view to understand the pattern in the data set. We create a heatmap with conditional formatting using built-in color scale rules. Figure 1. Heat Map How to Make a Heat Map Suppose we...
How to Copy a Worksheet in Excel
We may need to move or copy a worksheet as a backup. In this scenario, we can move or copy the sheet to another workbook or create a duplicate sheet in the same workbook. There are some quick methods to achieve this task. Figure 1. How to Copy a Sheet...
How to Add and Delete a Watermark in Excel
The watermark is an image used in the background of the worksheet labeled as copy, draft, confidential or a picture of the logo. The Excel 2010 and later versions do not have built-in watermarks, therefore we need to learn how to add and delete a watermark using the Header &...
1 2 6 7