256 Kilobytes

Spreadsheets Comments

Type CommentsResponses to top-level threads. Category SpreadsheetsSpreadsheet applications, such as LibreOffice Calc, Google Sheets, and Microsoft Excel

Profile Photo - August R. Garcia

Reply to Accounting assignment help Australia

Comments in Spreadsheets | By August R. Garcia

Published 1 month agoMon, 30 Dec 2019 06:56:09 -0800

Profile Photo - August R. Garcia

d

Mored
🗨
1
🐏
0
👁
5
Profile Photo - Univa

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

Comments in Spreadsheets | By Univa

Published 8 months agoFri, 31 May 2019 10:47:38 -0700

Profile Photo - Univa

The $ is used in a cell reference to cre...

MoreThe $ 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...
🗨
2
🐏
0
👁
314
Profile Photo - Hash Brown
Profile Photo - Hash Brown

Any opportunity to spit in the face of g...

MoreAny opportunity to spit in the face of god is good by me. Excellent post homie. 
🗨
2
🐏
2
👁
591
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

Re: "Scrape Data from Any (Public) Webpa...

MoreRe: "Scrape Data from Any (Public) Webpage" - There's a new post/video that demonstrates this type of scraping for email extraction, which can be foun...
🗨
2
🐏
2
👁
591
Profile Photo - Univa
Profile Photo - Univa

Create sheets by clicking the "+" button...

MoreCreate sheets by clicking the "+" button at the bottom of your browser window. In Sheet1, type this formula into any cell in column A: =INDIRECT("...
🗨
1
🐏
0
👁
277
Profile Photo - Univa

Reply to How to use the Quick Analysis tool in Excel 2016?

Comments in Spreadsheets | By Univa

Published 10 months agoMon, 22 Apr 2019 08:09:47 -0700

Profile Photo - Univa

More 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...
🗨
1
🐏
0
👁
297
Profile Photo - Univa

Reply to Finding outliers in Excel?

Comments in Spreadsheets | By Univa

Published 10 months agoMon, 22 Apr 2019 07:37:10 -0700

Profile Photo - Univa

By using Box and Whisker charts, you can...

MoreBy 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...
🗨
1
🐏
0
👁
282
Profile Photo - Univa

Reply to How to round number to nearest 5 in Excel?

Comments in Spreadsheets | By Univa

Published 10 months agoSat, 20 Apr 2019 09:03:37 -0700

Profile Photo - Univa

For rounding numbers to the nearest 5, y...

MoreFor 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...
🗨
1
🐏
0
👁
297
Profile Photo - Univa

Reply to How to split cells in Google Sheets?

Comments in Spreadsheets | By Univa

Published 10 months agoTue, 16 Apr 2019 07:58:40 -0700

Profile Photo - Univa

In Google Sheets, paste your data into a...

MoreIn 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...
🗨
1
🐏
0
👁
275
Profile Photo - roxblade

Reply to How to find and replace in Excel?

Comments in Spreadsheets | By roxblade

Published 10 months agoThu, 04 Apr 2019 04:37:24 -0700

Profile Photo - roxblade

Go to the Home tab on the ribbon. Here,...

MoreGo 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...
🗨
1
🐏
0
👁
287
Profile Photo - KacssPL

Reply to How to copy formulas in Google Sheets?

Comments in Spreadsheets | By KacssPL

Published 10 months agoSat, 30 Mar 2019 14:37:55 -0700

Profile Photo - KacssPL

Select the cell you would want to copy f...

MoreSelect 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...
🗨
1
🐏
0
👁
273
Profile Photo - WTCMolybdenam4753

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

Comments in Spreadsheets | By WTCMolybdenam4753

Published 10 months agoSat, 30 Mar 2019 14:03:29 -0700

Profile Photo - WTCMolybdenam4753

After searching on the internet, I found...

MoreAfter searching on the internet, I found this helpful link which seems to explain in detail about the Dollar Sign in Google sheets. Here is the link:...
🗨
2
🐏
0
👁
314
Profile Photo - -alxl_
Profile Photo - -alxl_

Having these error messages come up can...

MoreHaving 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...
🗨
1
🐏
0
👁
600
Profile Photo - Univa

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

Comments in Spreadsheets | By Univa

Published 10 months agoWed, 27 Mar 2019 11:41:15 -0700

Profile Photo - Univa

Follow the steps below to apply the form...

MoreFollow 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...
🗨
1
🐏
0
👁
244
Profile Photo - roxblade

Reply to How to tab in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoThu, 21 Mar 2019 01:07:37 -0700

Profile Photo - roxblade

I believe you mean another sheet, right?...

MoreI 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...
🗨
1
🐏
0
👁
253
Profile Photo - roxblade

Reply to How to alphabetize content in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:49:29 -0800

Profile Photo - roxblade

 > Open a spreadsheet in Google...

More > Open a spreadsheet in Google Docs.  > Select the group of cells that are to be sorted.  > Select Data and then > Sort...
🗨
1
🐏
0
👁
288
Profile Photo - roxblade

Reply to [Google Sheets] Conditional formatting based on row value?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:43:19 -0800

Profile Photo - roxblade

More Highlight the data range you want to conditionally format. Choose Format from the top menu > Select Conditional Formatting from the D...
🗨
1
🐏
0
👁
261
Profile Photo - roxblade

Reply to How to freeze a row in Excel?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:42:44 -0800

Profile Photo - roxblade

1. Open Excel > Open the Spreadsheet...

More1. 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...
🗨
1
🐏
0
👁
280
Profile Photo - roxblade

Reply to How to merge cells in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:42:16 -0800

Profile Photo - roxblade

1. Open Google Sheets.

More1. 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...
🗨
1
🐏
0
👁
271
Profile Photo - roxblade

Reply to How to wrap text in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:41:49 -0800

Profile Photo - roxblade

1. Select the cells to be wrapped.

More1. 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...
🗨
1
🐏
0
👁
294
Profile Photo - roxblade

Reply to How to lock a row in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:41:27 -0800

Profile Photo - roxblade

1. Open Google Sheets.

More1. 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.
🗨
1
🐏
0
👁
257
Profile Photo - roxblade
Profile Photo - roxblade

This error might have happened due to Dy...

MoreThis error might have happened due to Dynamic Data Exchange feature in Microsoft Office. The simple solution is to disable it. 1. Open Excel &gt...
🗨
1
🐏
0
👁
273
Profile Photo - roxblade

Reply to How to make a drop down list in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:40:30 -0800

Profile Photo - roxblade

 Open Google Sheets.

More Open Google Sheets. Select the cells for creating the drop-down menu. Data > Data Validation. There will be an optio...
🗨
1
🐏
0
👁
283
Profile Photo - roxblade

Reply to How to sort in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:39:16 -0800

Profile Photo - roxblade

1. Open Google Sheets.

More1. 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...
🗨
1
🐏
0
👁
268
Profile Photo - roxblade

Reply to How to add columns in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:37:52 -0800

Profile Photo - roxblade

1. Open Spreadsheet in Google Sheets.<br...

More1. Open Spreadsheet in Google Sheets. 2. Select the number of rows or columns you want to add. ( Mac Command + click, Windows Ctrl + Click). 3....
🗨
1
🐏
0
👁
275
Profile Photo - roxblade

Reply to How to zoom out in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 11 months agoWed, 27 Feb 2019 15:35:43 -0800

Profile Photo - roxblade

1. Open Google Sheets.

More1. 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.
🗨
1
🐏
0
👁
258
Profile Photo - Some Guy
Profile Photo - Some Guy

Bonus note. If the value in F2 does...

MoreBonus 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:...
🗨
1
🐏
0
👁
6
Profile Photo - roxblade

Reply to How to count non-blank cells in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 1 year agoThu, 24 Jan 2019 04:59:32 -0800

Profile Photo - roxblade

The count function does the counting for...

MoreThe count function does the counting for you. Like =COUNT(A2:A11). But it also ignores hidden contents like "" (empty string) or a space. Th...
🗨
1
🐏
0
👁
268
Profile Photo - roxblade

Reply to [Google Sheets] Remove/find/highlight duplicates?

Comments in Spreadsheets | By roxblade

Published 1 year agoThu, 24 Jan 2019 04:45:07 -0800

Profile Photo - roxblade

Finding and highlighting is pretty much...

MoreFinding 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...
🗨
1
🐏
0
👁
1
Profile Photo - roxblade

Reply to How to freeze a row in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 1 year agoThu, 24 Jan 2019 04:41:25 -0800

Profile Photo - roxblade

Freezing a row is easy on Google Sheets....

MoreFreezing 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...
🗨
2
🐏
0
👁
281