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...
Last ReplyHello, Press Ctrl and then click (or drag) over the cells you want to deselect. HTH Hash Brown,
Hello,
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...
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...
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...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...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...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...Steps to follow when arrow keys are not working in Excel?
Answers in Spreadsheets | By Some Guy
Published
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?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...How to set conditional formatting based on another cell in Excel?
Answers in Spreadsheets | By Some Guy
Published
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.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?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...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...