256 Kilobytes

Spreadsheets Answers > Software

Type AnswersAsk and answer questions, if that is something that you want to do. 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
👁 583
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
👁 388
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
👁 368
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
👁 363
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
👁 358
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
👁 337
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
👁 314
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
👁 365
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
👁 305
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
👁 359
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
👁 350
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
👁 343
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
👁 319
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
👁 351