How to change bin number/width in a histogram in Excel for Mac (Office 2020)
Hello, I have created a histogram and now I want to modify the width and number of the bins. Can someone please advise? When I select 'format axis' there is no option to modify bin (see attached). I have seen various videos and web pages that show how to do this in Excel 2016 and later, so I am confused as to why bin width/number is apparently hard wired in my Excel (2020 Microsoft 365, Excel version 16.41). Thank you for your help.
Remove Password from Excel Spreadsheet
I created a password for my spreadsheet, and now want to REMOVE the password. Is there a SIMPLE, EASY way to do so? If not, there SHOULD BE, and I am very frustrated with Microsoft right now, trying to sort it out! I have clicked on INFO, and there are NO options to unprotect a document. I have clicked on REVIEW, and there are NO options to unprotect a document! Thanks for your help!
Turn Off Read Only
Hey guys, Hoping someone can help out with this, there are 5 of us here in the office all using our boss' Microsoft office licence. Mainly using excel and unable to open Excel files at the same time without getting 'Read-only' access while opening. Is there anyway this can be removed so we can all save the same file?
VBA help for a Macro (inserting picture from file)
Hi, I am new to VBA and macros and I was hoping that someone could help me writing the VBA to insert a photo from your personal files. I created the button, but I just need to write the VBA to pull up the users files so they can select the photo. From there I want the photo to be placed in the cell (you'll see on the sheet which cell I am referring to). The cells are already merged together. I want the photo to fit in the cell that is already merged. For some reason this forum won't let me upload a macro, so I am going to insert the excel file. You'll see where I want the photo's on the "FLYER V1" tab. Thanks! Let me know if you have any questions
Excel - how to show a negative time calculation
I am creating a time sheet that calculates the time used against a starting amount of hours purchased for consulting. I have used the "time" calculation to delete the time used. I have now got to where negative time has been used from the hours purchased. The help section tells me to switch to the "1904 data system" to allow the formula to show a negative number. I have gone to Excel File but do not see the "option" that is explained in help. Any other suggestions. For Example: The client has purchased 20 hours of consulting time.Get external data from web not showing
Hello, I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea why this might be happening? See attached a screenshot of what I'm getting. Shouldn't that option be appearing between the "From HTML" and "From Text" options? I'm on Microsoft Excel for Mac, version 16.23 (19.03.09) Thanks in advance, PedroConditional Formatting Row by Row
Good morning! I am working on a project for my office and need some assistance to make the project easier to update and less bulky now. We have several (about 4000) rows of data separated into 4 tabs that need to be "heat mapped" individually row by row. In order to do this, I have been using conditional formatting with 3-Color Scale. Currently however I am having to duplicate and update each row with its own formula, which means that I would end up with thousands of different rules. Is there an "applies to" set or formula that could be used so that only one rule can account for the whole sheet tab by tab? I'm using Excel on a MacBook. Thank you in advance for all your assistance in advance!
