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
Profile Photo - August R. Garcia

d

Mored
🗨 1
🐏 0
👁 6
Profile Photo - August R. Garcia

Reply to Accounting assignment help Australia

Comments in Spreadsheets | By August R. Garcia

Published

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

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
👁 421
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
👁 390
Profile Photo - Univa

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

Comments in Spreadsheets | By Univa

Published

Profile Photo - Univa

MoreSelect 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
👁 415
Profile Photo - Univa

Reply to Finding outliers in Excel?

Comments in Spreadsheets | By Univa

Published

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
👁 409
Profile Photo - Univa

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

Comments in Spreadsheets | By Univa

Published

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
👁 428
Profile Photo - Univa

Reply to How to split cells in Google Sheets?

Comments in Spreadsheets | By Univa

Published

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
👁 401
Profile Photo - roxblade

Reply to How to find and replace in Excel?

Comments in Spreadsheets | By roxblade

Published

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
👁 406
Profile Photo - KacssPL

Reply to How to copy formulas in Google Sheets?

Comments in Spreadsheets | By KacssPL

Published

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
👁 383
Profile Photo - WTCMolybdenam4753
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
👁 421
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
👁 861
Profile Photo - Univa

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

Comments in Spreadsheets | By Univa

Published

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
👁 352
Profile Photo - roxblade

Reply to How to tab in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 352
Profile Photo - roxblade

Reply to How to alphabetize content in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 389
Profile Photo - roxblade
Profile Photo - roxblade

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

Reply to How to freeze a row in Excel?

Comments in Spreadsheets | By roxblade

Published

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
👁 396
Profile Photo - roxblade

Reply to How to merge cells in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 371
Profile Photo - roxblade

Reply to How to wrap text in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 416
Profile Photo - roxblade

Reply to How to lock a row in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 366
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
👁 360
Profile Photo - roxblade

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

Comments in Spreadsheets | By roxblade

Published

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
👁 384
Profile Photo - roxblade

Reply to How to sort in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 403
Profile Photo - roxblade

Reply to How to add columns in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 375
Profile Photo - roxblade

Reply to How to zoom out in Google Sheets?

Comments in Spreadsheets | By roxblade

Published

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
👁 355
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

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
👁 377
Profile Photo - roxblade

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

Comments in Spreadsheets | By roxblade

Published

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