3,980 questions
3,980 questions with Microsoft 365 and Office | Excel | For business | Windows tags
1 answer
How do I turn off automatic date conversion in excel?
I work as a network engineer, we recently moved from Cisco to Aruba. Aruba does not prefix its port labels with anything its just numbers and slashes. So I'm working with multiple CSV files a day that I have to manually run data import on, or run regex…
Microsoft 365 and Office | Excel | For business | Windows
asked 2025-07-08T14:53:58.2866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 1%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Justin Stewart
0
Reputation points
commented 2025-07-14T05:21:47.7266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Flora-T
1,295
Reputation points Microsoft External Staff
Moderator
1 answer
How to bring comments/notes back into view?
All comments/notes in one of my Excel worksheets got pushed beyond visible range when the file was moved to a new computer. I can manually move it back into view and resize it back to its original look, but I can't do that for thousands of cells. It was…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 9%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYL%3C/text%3E%3C/svg%3E)
1 answer
Ctrl+P shortcut is no longer short :(
/* Rant Alert */ It seems Ctrl+P no longer takes you to the print preview with focus on the "print" button. This is ridiculous. When I press Ctrl+P I want to print. That has been the shortcut for ever and a day. Now, apparently Ctrl+P is…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-07T17:14:41.44+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPE%3C/text%3E%3C/svg%3E)
Peter England
5
Reputation points
commented 2025-07-14T04:20:41.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 88%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sherman Buck
0
Reputation points
1 answer
How can I conditionally format cells based on complex parameters
The days of the year across the top - want the formatting to only reference by day. There are different titles of training down the left column with various training rooms under each one. The training rooms repeat. If anyone claims the room (types info…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-07T13:22:48.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 74%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Darlene Ashley (TBMNC)
0
Reputation points
commented 2025-07-14T04:14:39.0766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dora-T
2,275
Reputation points Microsoft External Staff
Moderator
1 answer
Why do my Microsoft Office apps close moments after opening?
When I have an Excel document or presentation open, it frequently closes after just a few moments. This is annoying and time-consuming to keep having to reopen the file on which I am working.
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-10T19:50:43.5266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 7.000000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jennifer Murray
0
Reputation points
commented 2025-07-14T03:19:07.1466667+00:00
Dora-T
2,275
Reputation points Microsoft External Staff
Moderator
1 answer
Microsoft Excel appearance changed suddenly
, I noticed a change in the appearance of the tabs, ribbon, etc.
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
Not getting 'Format Comment' in my Excel
I want to enlarge the text in an Excel comment. Several places on the web tell me to select the comment text, then right-click and choose Format Comment. I've tried this several times, including with variations: e.g. selecting all the text in a comment…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-09T11:24:48.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 95%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kirk Hansen
20
Reputation points
commented 2025-07-14T02:13:57.3+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
Gabriel-N
2,660
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How can I remove these lines in Excel? I’m not sure why they appeared.
Lines have appeared in the cells like in this photo. They weren’t added intentionally like strikethroughs — they just showed up automatically, and I don’t know why. How can I fix this?
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 6%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Remove Excel "Quick Access"
Remove the "Quick Access" section in Excel. It is full of trash that I did not personally add to "Quick Access". Will you idiots please stop pimping your trash? We're already paying customers. I do not want to be pimped your…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-08T12:48:28.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 39%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Patrick Henry
211
Reputation points
commented 2025-07-14T02:10:37.7333333+00:00
Gabriel-N
2,660
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How to fix text size in apps eg Outlook after windows update
The program text size is so small i can hardly read it in all microsoft programs after a windows update!
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-11T01:25:01.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 35%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
lyndel small
20
Reputation points
accepted 2025-07-14T00:41:49.78+00:00
lyndel small
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Incorrect Sum Calculation in Excel Spreadsheet
In a budget spreadsheet created with Microsoft 365 and OneDrive, one of the columns intended for summing values in the budget category is yielding an incorrect total. The spreadsheet has a row for each day of the month and calculates the sum of all…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-13T18:34:00.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 82%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Tom Boland
20
Reputation points
accepted 2025-07-13T20:02:11.6166667+00:00
Tom Boland
20
Reputation points
2 answers
Excel not sorting columns with calculations and possible solution
I have an Excel table with some columns containing SUMIF calculations from a larger data sheet. (Summing all the values relating to a particular identifier), Some of the columns in my summary table would not sort correctly. A cell in the table…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-13T13:26:14.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 15%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Michael Green
0
Reputation points
answered 2025-07-13T13:34:00.0933333+00:00
Michael Green
0
Reputation points
0 answers
adding multiple buttons to a spread sheet
Hi Folks, I am struggling with my first attempt to add buttons into an excel sheet I can get the first one to work it is to create a pdf but the next one I am trying to add is to save and create email it keeps failing I am not too good with…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 9%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
1 answer
I'm getting this error message that says "This command isn't available" (error messages in Word and Excel for Windows)
I first noticed this problem with Excel, but I decided to try Word and got the same message. The commands were to get help and initially in Excel I just wanted to get the column to fit the width of the text, something I have done multiple times in the…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-11T23:59:15.3333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 35%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Susan Carlsen
0
Reputation points
edited a comment 2025-07-12T19:05:14.3533333+00:00
Stefan Blom
3,591
Reputation points MVP
Volunteer Moderator
0 answers
Porque al vincular una celda con otra aparece la instrucción COEFK
Hola, estoy teniendo un problema con un archivo Excel. Estoy armando un presupuesto e intento vincular un valor de una celda de una hoja con otra celda de otra hoja. Al hacerlo, aparece en la barra de instrucciones =COEFK y se muestra un valor erróneo,…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-12T17:17:27.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 71%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Matias Borracer
0
Reputation points
commented 2025-07-12T18:21:59.09+00:00
Matias Borracer
0
Reputation points
0 answers
how to unlock a protected sheet and i know the password is correct
have the correct password but it keeps saying to check the caps lock and or the correct capitalization. what can I do?
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-12T14:25:32.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 40%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Pierce, Bonnie J
0
Reputation points
asked 2025-07-12T14:25:32.5+00:00
Pierce, Bonnie J
0
Reputation points
1 answer
How to find lost Excel file from yesterday
I worked on a file in excel yesterday it is now gone
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-11T17:37:34.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 28.999999999999996%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Richard Tracey
0
Reputation points
answered 2025-07-12T13:52:49.7933333+00:00
Pavle Pekovic
85
Reputation points
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Can Power BI be used to track job post engagement?
I want to track which types of jobs get the most user interest on our platform, especially for categories like part time jobs in Dubai. Is there a simple way to connect our traffic or listing data (currently in Google Sheets or Excel) to Power BI and…
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-08T12:32:55.1666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 57.99999999999999%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Sarah Jacob
20
Reputation points
accepted 2025-07-12T12:02:48.7433333+00:00
Sarah Jacob
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How to use vlookup
I have never used functions in Excel. I want to use VLOOKUP to find a result from a predetermined column and a varying row. I have the VLOOKUP function cell created, I get an answer but I do not know how to apply a new row to my predetermined column.
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 99%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
0 answers
create a hover function to show a picture in an excel cell that has a date in it
is there a way to create a hover function in excel over a cell that shows a date so that when you hover an image is shown? used to be able to do it simply with comments but comments in a cell have changed
Microsoft 365 and Office | Excel | For business | Windows
3,980 questions
asked 2025-07-11T15:59:23.5466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 3%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Carrie Cook
5
Reputation points
asked 2025-07-11T15:59:23.5466667+00:00
Carrie Cook
5
Reputation points