In this DataSherpas quick tip we show you how to make a graph in Google Sheets. Graphs in any spreadsheet application, including Google Sheets, can help really tell a story with your data more visually and help bring your data to life. We are going to cover how to add three popular types of graphs … Read more
A DataSherpas Quick Tip. In this quick tip article we show you how to hide and unhide columns in Google Sheets. Hiding and unhiding columns is a very simple and quick process and there are even keyboard shortcuts to help speed things up even more. Let’s get started. Hiding Columns Open up your Google Sheet. … Read more
A DataSherpas Quick Tip. In this quick tip we show you how to total or sum a column in Google Sheets. Using a few simple shortcuts you can quickly and easily add together a set of numbers in a column to get a total. It takes just a few clicks of the mouse. Let’s get … Read more
A DataSherpas Quick Tip. In this quick tip we show you how to add columns in Google Sheets. It’s a really quick process and will take you just a few seconds if you are adding one or multiple columns. Let’s get started. So you have your Google Sheet. You want to add an extra column … Read more
A DataSherpas Quick Tip. In this quick tip we will show you how to rotate text in Excel. The process is very simple and quick, but we are sure that you will use this feature regularly to style and format your Excel spreadsheets. In our example below we have a large cell containing data and … Read more
A DataSherpas Quick Tip. This quick tip gives you a step by step guide for how to merge and center in Excel. Merging and centering cells in Excel is usefu when you need to format your data in specific ways for ensuring the information contained in your spreadsheet is easy to read or presented in … Read more
A DataSherpas Quick Tip. Quite often you will face the issue of how to display a long piece of text in Google Sheets. In this quick tip article we show you how to wrap text in Google Sheets. This allows you to display a large amount of text or other data, that will usually display … Read more
A DataSherpas Quick Tip. In this quick tip article we explain how to freeze columns in Google Sheets. The process is very similar to that explained in our recent quick tip article – How to freeze a row in Google Sheets. The most frequent use for freezing columns is to freeze the first column so … Read more
A DataSherpas Quick Tip. In this quick tip article we will show you how to freeze a row in Google Sheets. Sometimes for usability it helps to freeze one or multiple rows at the top of your Google Sheet. When you have a lot of rows of data, where the user of the Google Sheet … Read more
A DataSherpas Quick Tip. In this DataSherpas quick tip we guide you through the process of how to remove a hyperlink in Excel. We have all been there – we have either inherited a spreadsheet or created an Excel spreadsheet with hyperlinks or imported data into a spreadsheet and hyperlinks have been automatically added. Now … Read more
A DataSherpas Quick Tip. In this DataSherpas quick tip we take you through step by step instructions to show you how to create a drop down list in Google Sheets. Drop down lists are a very popular for ensuring data input is consistent and validated in your Google Sheet and is particularly useful when you … Read more
A DataSherpas Quick Tip. In this DataSherpas quick tip we show you how to highlight every other row in excel. Although row highlighting is mainly used for presentation purposes, highlighting alternate rows in an Excel worksheet can also help usability and help to highlight important data. The process for highlighting every other row in Excel … Read more
A DataSherpas Quick Tip. In this quick tip we show you how to lock cells in Google Sheets. Locking cells is useful if you want to prevent other people that view or edit your Google Sheet from editing important information that maybe contained in the sheet. You may have values in your sheet that should … Read more
A DataSherpas Quick Tip. Merging cells in Excel gives us great flexibility when it comes to formatting data, providing descriptive headings and titles to a group of cells or providing useful help information for other users of our Excel Spreadsheet. But what if we want to unmerge those merged cells to change the layout or … Read more
A DataSherpas Quick Tip. Merging cells in Google Sheets may be helpful in a few different scenarios, for example: Cells can be merged either horizontally, across rows; or vertically down columns; or both. In this quick tip article we explain how how to merge cells on Google Sheets, with step by step instructions, screen shots, … Read more