256 Kilobytes

Spreadsheets

Type All Category SpreadsheetsSpreadsheet applications, such as LibreOffice Calc, Google Sheets, and Microsoft Excel Tag All

Profile Photo - August R. Garcia

Spit in the Face of God: Five Tasks You Didn’t Know Could be Done with Google Sheets

Articles in Spreadsheets | By August R. Garcia

Published 7 months agoTue, 12 Feb 2019 07:53:13 -0800 | Last update 6 months agoThu, 28 Feb 2019 22:37:26 -0800 📌

Profile Photo - Hash Brown

Last Reply Any opportunity to spit in the face of god is good by me. Excellent post homie.  Hash Brown,

Any opportunity to spit i...

Mon, 27 May 2019 07:59:54 -0700 3 months ago
🗨
2
🐏
2
👁
1,842
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

The answer is to fucking kill yourself.<...

MoreThe answer is to fucking kill yourself.
🗨
0
🐏
0
👁
100
Profile Photo - Some Guy

[Google Sheets] Dollar sign usage? What does it do?

Answers in Spreadsheets | By Some Guy

Published 7 months agoWed, 06 Feb 2019 14:35:22 -0800

Profile Photo - Univa

Last Reply The $ is used in a cell reference to create an absolute reference. An absolute reference is one that will not change when the formula is copied. Th... Univa,

The $ is used in a cell r...

Fri, 31 May 2019 10:47:38 -0700 3 months ago
🗨
2
🐏
0
👁
211
Profile Photo - Some Guy
Profile Photo - Univa

Last Reply Create sheets by clicking the "+" button at the bottom of your browser window. In Sheet1, type this formula into any cell in column A: =INDIRECT("... Univa,

Create sheets by clicking...

Thu, 16 May 2019 08:10:10 -0700 4 months ago
🗨
1
🐏
0
👁
190
Profile Photo - Some Guy

How to use the Quick Analysis tool in Excel 2016?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:31:51 -0800

Profile Photo - Univa

Last Reply Select the cells of data that you want to analyze Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Click it Rol... Univa,

Mon, 22 Apr 2019 08:09:47 -0700 4 months ago
🗨
1
🐏
0
👁
201
Profile Photo - Some Guy

Finding outliers in Excel?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:37:00 -0800

Profile Photo - Univa

Last Reply By using Box and Whisker charts, you can easily identify outliers of your data, and it shows you where the data lies in and outside your inner quartil... Univa,

By using Box and Whisker...

Mon, 22 Apr 2019 07:37:10 -0700 4 months ago
🗨
1
🐏
0
👁
175
Profile Photo - Some Guy

How to round number to nearest 5 in Excel?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:35:18 -0800

Profile Photo - Univa

Last Reply For rounding numbers to the nearest 5, you can use the formula =MROUND(number,5) Let's take an example that in cell B contains number 17 in Row 6 a... Univa,

For rounding numbers to t...

Sat, 20 Apr 2019 09:03:37 -0700 4 months ago
🗨
1
🐏
0
👁
193
Profile Photo - Some Guy

How to split cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:33:30 -0800

Profile Photo - Univa

Last Reply In Google Sheets, paste your data into a column. You’ll see a little clipboard icon appear in the lower right-hand corner of your data. Click on... Univa,

In Google Sheets, paste y...

Tue, 16 Apr 2019 07:58:40 -0700 5 months ago
🗨
1
🐏
0
👁
181
Profile Photo - Some Guy

How to find and replace in Excel?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:43:56 -0800

Profile Photo - roxblade

Last Reply Go to the Home tab on the ribbon. Here, click on the Find and Select button. In the drop-down that appears, choose Replace. Find and Replace was al... roxblade,

Go to the Home tab on the...

Thu, 04 Apr 2019 04:37:24 -0700 5 months ago
🗨
1
🐏
0
👁
189
Profile Photo - Some Guy

How to copy formulas in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 7 months agoWed, 06 Feb 2019 14:50:14 -0800

Profile Photo - KacssPL

Last Reply Select the cell you would want to copy from the formula and select edit on the toolbar. Once selected navigate to copy and you can then paste the form... KacssPL,

Select the cell you would...

Sat, 30 Mar 2019 14:37:55 -0700 5 months ago
🗨
1
🐏
0
👁
173
Profile Photo - Some Guy
Profile Photo - -alxl_

Last Reply Having these error messages come up can be frustrating to work with. Without seeing specifics/knowing more of the spreadsheet you deal with it can be... -alxl_,

Having these error messag...

Sat, 30 Mar 2019 13:46:47 -0700 5 months ago
🗨
1
🐏
0
👁
288
Profile Photo - Some Guy

How to apply a formula to an entire column in Excel?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:37:55 -0800

Profile Photo - Univa

Last Reply Follow the steps below to apply the formula quickly to entire rows or columns in Excel. METHOD 1: Drag the fill handle to copy the formula In... Univa,

Follow the steps below to...

Wed, 27 Mar 2019 11:41:15 -0700 5 months ago
🗨
1
🐏
0
👁
152
Profile Photo - Some Guy

How to tab in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 7 months agoWed, 06 Feb 2019 15:02:45 -0800

Profile Photo - roxblade

Last Reply I believe you mean another sheet, right? On the bottom of the screen, you will find a bar that houses your sheet on the left. Further left and, in fac... roxblade,

I believe you mean anothe...

Thu, 21 Mar 2019 01:07:37 -0700 5 months ago
🗨
1
🐏
0
👁
171
Profile Photo - Some Guy

How to alphabetize content in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 02 Dec 2018 03:42:37 -0800

Profile Photo - roxblade

Last Reply  > Open a spreadsheet in Google Docs.  > Select the group of cells that are to be sorted.  > Select Data and then > Sort... roxblade,

 > Open a spreads...

Wed, 27 Feb 2019 15:49:29 -0800 6 months ago
🗨
1
🐏
0
👁
194
Profile Photo - Some Guy

[Google Sheets] Conditional formatting based on row value?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:11:34 -0800

Profile Photo - roxblade

Last Reply Highlight the data range you want to conditionally format. Choose Format from the top menu > Select Conditional Formatting from the D... roxblade,

Wed, 27 Feb 2019 15:43:19 -0800 6 months ago
🗨
1
🐏
0
👁
176
Profile Photo - Some Guy

How to freeze a row in Excel?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:11:54 -0800

Profile Photo - roxblade

Last Reply 1. Open Excel > Open the Spreadsheet you want to edit. 2. Select the row below the rows that you want to freeze. Example: To Freeze Row 1, Selec... roxblade,

1. Open Excel > Open t...

Wed, 27 Feb 2019 15:42:44 -0800 6 months ago
🗨
1
🐏
0
👁
184
Profile Photo - Some Guy

How to merge cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:13:24 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Open the file. 3. Select the cells you want to merge. 4. Click on the merge option on the above toolbar. The merge... roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:42:16 -0800 6 months ago
🗨
1
🐏
0
👁
181
Profile Photo - Some Guy

How to wrap text in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:13:34 -0800

Profile Photo - roxblade

Last Reply 1. Select the cells to be wrapped. 2. On the Menu, click on Format. 3. On the Menu > Click on Text Wrapping > Select Wrap. 4. The proce... roxblade,

1. Select the cells to be...

Wed, 27 Feb 2019 15:41:49 -0800 6 months ago
🗨
1
🐏
0
👁
198
Profile Photo - Some Guy

How to lock a row in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:13:44 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Go to the View Menu. 3. Point your mouse to Freeze Rows. 4. You will be able to see the Frozen Rows. roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:41:27 -0800 6 months ago
🗨
1
🐏
0
👁
167
Profile Photo - Some Guy

Fix for "Excel there was a problem sending the command to the program?"

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:14:14 -0800

Profile Photo - roxblade

Last Reply This error might have happened due to Dynamic Data Exchange feature in Microsoft Office. The simple solution is to disable it. 1. Open Excel &gt... roxblade,

This error might have hap...

Wed, 27 Feb 2019 15:41:06 -0800 6 months ago
🗨
1
🐏
0
👁
189
Profile Photo - Some Guy

How to make a drop down list in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:14:24 -0800

Profile Photo - roxblade

Last Reply  Open Google Sheets. Select the cells for creating the drop-down menu. Data > Data Validation. There will be an optio... roxblade,

 Open Google Sheets.

Wed, 27 Feb 2019 15:40:30 -0800 6 months ago
🗨
1
🐏
0
👁
194
Profile Photo - Some Guy

How to sort in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:13:54 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Select the number of rows/columns / cells. Click on the top left corner to sort the entire sheet. 3. Click on Data &gt... roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:39:16 -0800 6 months ago
🗨
1
🐏
0
👁
171
Profile Photo - Some Guy

How to add columns in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:14:04 -0800

Profile Photo - roxblade

Last Reply 1. Open Spreadsheet in Google Sheets. 2. Select the number of rows or columns you want to add. ( Mac Command + click, Windows Ctrl + Click). 3.... roxblade,

1. Open Spreadsheet in Go...

Wed, 27 Feb 2019 15:37:52 -0800 6 months ago
🗨
1
🐏
0
👁
188
Profile Photo - Some Guy

How to zoom out in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 8 months agoSun, 13 Jan 2019 04:14:34 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Click on 100% on the toolbar and you will see values from 50-200 appear. 3. Select 50/75 if you want to zoom out. roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:35:43 -0800 6 months ago
🗨
1
🐏
0
👁
181
Profile Photo - August R. Garcia

Custom Capitalization in Google Sheets -- Handle Acronyms, Industry Terms, Etc. in Titles

Articles in Spreadsheets | By August R. Garcia

Published 7 months agoFri, 01 Feb 2019 23:06:44 -0800 | Last update 7 months agoFri, 01 Feb 2019 23:12:43 -0800

Profile Photo - Some Guy

Last Reply Bonus note. If the value in F2 does not contain any question marks, add a question mark at the end; otherwise, get the unmodified string in F2:... Some Guy,

Bonus note. If the value...

Fri, 01 Feb 2019 23:46:51 -0800 7 months ago
🗨
1
🐏
0
👁
278
Profile Photo - Some Guy

How to count non-blank cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:26:56 -0800

Profile Photo - roxblade

Last Reply The count function does the counting for you. Like =COUNT(A2:A11). But it also ignores hidden contents like "" (empty string) or a space. Th... roxblade,

The count function does t...

Thu, 24 Jan 2019 04:59:32 -0800 7 months ago
🗨
1
🐏
0
👁
180
Profile Photo - Some Guy

[Google Sheets] Remove/find/highlight duplicates?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 02 Dec 2018 03:45:45 -0800 | Last update 9 months agoSun, 02 Dec 2018 12:27:38 -0800

Profile Photo - roxblade

Last Reply Finding and highlighting is pretty much the same thing when it comes to handling duplicate cells. Removal has to be manual. Here's the simple proc... roxblade,

Finding and highlighting...

Thu, 24 Jan 2019 04:45:07 -0800 7 months ago
🗨
1
🐏
0
👁
202
Profile Photo - Some Guy

How to freeze a row in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 02 Dec 2018 03:42:31 -0800

Profile Photo - roxblade

Last Reply Freezing a row is easy on Google Sheets. You need to open the sheet in question, go to View, and then go to the option "Freeze rows" or &quo... roxblade,

Freezing a row is easy on...

Thu, 24 Jan 2019 04:41:25 -0800 7 months ago
🗨
2
🐏
0
👁
196
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last Reply From the Google Sheets documentation: To format an entire row based on the value of one of the cells in that row: On your computer, open a... August R. Garcia,

From the Google Sheets do...

Fri, 18 Jan 2019 23:12:06 -0800 8 months ago
🗨
1
🐏
0
👁
203
Profile Photo - Some Guy

How to merge cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 9 months agoSun, 02 Dec 2018 03:43:16 -0800

Profile Photo - Hash Brown

Last Reply Yes this is very possible, not even hard if you know what you're doing. Highlight the cells you want to merge and then click this button. Hash Brown,

Yes this is very possible...

Tue, 15 Jan 2019 19:08:33 -0800 8 months ago
🗨
1
🐏
0
👁
208