256 Kilobytes

Spreadsheets > Software

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

Profile Photo - Some Guy

How to round number to nearest 5 in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Univa

Last ReplyFor 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 -07002 years ago1
🗨 1
🐏 0
👁 600
Profile Photo - Some Guy

How do you deselect in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyHello, Press Ctrl and then click (or drag) over the cells you want to deselect. HTH Hash Brown,

Hello,

Sat, 12 Jan 2019 18:04:28 -08002 years ago1
🗨 1
🐏 0
👁 400
Profile Photo - Some Guy

How to separate first and last name in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyIn Google Sheets, you can split cells at a space with this formula: =SPLIT(A1, " ") It is probably the same or comparable in Exce... August R. Garcia,

In Google Sheets, you can...

Fri, 04 Jan 2019 13:26:53 -08002 years ago1
🗨 1
🐏 0
👁 384
Profile Photo - Some Guy

How to number rows in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyExcel has a ROW() function that will return the row that the function is called in. You can add numbers to cells by row by adding =ROW() to the first... August R. Garcia,

Excel has a ROW() functio...

Wed, 19 Dec 2018 10:45:56 -08002 years ago1
🗨 1
🐏 0
👁 379
Profile Photo - Some Guy

How to label axis on excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I had a question about graphs in Excel....

MoreI had a question about graphs in Excel. I need to put labels on the axes, but I can't figure out how. It seems like it should be easy, but I&#03...
🗨 0
🐏 0
👁 371
Profile Photo - Some Guy

How to switch x and y axis in excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I created a graph in Microsoft Excel to...

MoreI created a graph in Microsoft Excel to plot two sets of data values. The program automatically sets one set of values for the x-axis and another set...
🗨 0
🐏 0
👁 352
Profile Photo - Some Guy

How to freeze panes in Excel to lock rows or columns?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

When I'm scrolling through the data...

MoreWhen I'm scrolling through the data in microsoft excel, I want to keep the top row frozen so I can see what category the column is in. How do I f...
🗨 0
🐏 0
👁 328
Profile Photo - Some Guy

How to change horizontal axis values in excel 2016?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I have been using Excel 2016 lately and...

MoreI have been using Excel 2016 lately and it's pretty intuitive. But I can't work out how to enter new values for the position of the horizont...
🗨 0
🐏 0
👁 377
Profile Photo - Some Guy

Steps to follow when arrow keys are not working in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

In microsoft excel, my arrow keys are no...

MoreIn microsoft excel, my arrow keys are not working. what are the steps/process i can take to fix this error?
🗨 0
🐏 0
👁 317
Profile Photo - Some Guy

How to convert formulas to values in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I've spent the last 30 minutes tryi...

MoreI've spent the last 30 minutes trying to convert formulas to values in Excel. I still can't figure it out. Does anyone have some detailed in...
🗨 0
🐏 0
👁 371
Profile Photo - Some Guy

How to set conditional formatting based on another cell in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I am currently using excel and needed to...

MoreI am currently using excel and needed to know how I can set conditional formatting based on another cell. Please let me know quickly.
🗨 0
🐏 0
👁 361
Profile Photo - Some Guy

Editing legend names in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I am looking to edit the legend names in...

MoreI am looking to edit the legend names in Microsoft Excel- can anyone provide me some guidance on how to do so?
🗨 0
🐏 0
👁 352
Profile Photo - Some Guy

How to unhide rows in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

i got on the microsoft office this morni...

Morei got on the microsoft office this morning on my PC this morning and i found it difficult to unhide rows in my microsoft excel software application,p...
🗨 0
🐏 0
👁 329
Profile Photo - Some Guy

How to normalize data in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I've recently started using Excel,...

MoreI've recently started using Excel, and while I think I have a pretty good grasp of the general program, I cannot for the life of me figure out ho...
🗨 0
🐏 0
👁 362