User Profile
Steve_K_Excel
Iron Contributor
Joined 10 years ago
User Widgets
Recent Discussions
Re: Paste formulas from Excel into Word not working
If you are trying to copy/paste a single formula from Excel into Word, the easiest way is to select the cell, then go to the formula bar and select the formula text. Copy it using CTRL+C, then paste it into Word. If you need more than a single formula, an easy way would be to create a range of cells in your workbook with formulas like "=FORMULATEXT(A1)", with A1 being the appropriate references in your spreadsheet. Then you can select the range of cells that show the formula text, copy, and paste into Word. There should be no need to paste-link.Re: Keyboard Shortcuts Not Working
richardmanley3 It is expected for the shortcuts to be grayed out on the menus. This is a style change in a recent Mac OS update. You should see the same in all apps. Here's a screen shot of the menu from Mac's Finder app, showing that the shortcuts are grayed out. If the shortcuts aren't working, that's unexpected. At the moment, I don't have a way to reproduce the issue, so it's difficult to investigate. We have not received much feedback about this, so it doesn't seem to be affecting many. Any information about what happens between the shortcuts working as expected and then not working, please share it here.Re: Keyboard Shortcuts Not Working
If this problem continues to happen, please send feedback from within the app (Help menu > Feedback > I don't like something), and then reply here to let us know that you have sent feedback. If willing, please fill in the email field in the feedback form so that it's possible to contact you in case more information is required. When you send feedback, it includes some diagnostic information about your computer which may help investigate the issue.Re: Please tell me what I am doing incorrectly-Excel SUBTOTAL Function 9 and 109 return the same Results
Thanks for the detailed description of your scenario. I think the descriptions in the help article can be improved. The important point is to know how SUBTOTAL defines "hidden". For a row to be considered manually hidden, it means that the entire row is not shown. You can do this by selecting a row, then right-click on it and choose "Hide" from the menu. If you can see the row at all, then it's not hidden, even if you've set the format of the cell so that the value in the cell is not visible. It would be better for the help to say that function_num 9 includes hidden "rows" rather than hidden "values" and that 109 ignores or excludes hidden "rows" rather than "values". If the range has a filter applied, then the values in the hidden rows will not be included by either of the function_nums. Here's an article about filtering - https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e. The Office apps are supported on Mac OS running on M1 chips - https://support.microsoft.com/en-us/office/microsoft-365-office-2021-and-office-2019-support-for-apple-silicon-c55b603e-14a6-4b69-bdc0-2bb4c9a36834.Re: Please tell me what I am doing incorrectly-Excel SUBTOTAL Function 9 and 109 return the same Results
Gelphyn From looking at the workbook, there are values in the cells for the "V" rows, but the format causes the value to not be visible. The Excel SUBTOTAL function does not consider these to be hidden, since the rows are not hidden. If you use a filter to filter out the "V" rows, they will be hidden and the subtotal result should be as expected. You could also hide the rows by right-clicking on the row number and choosing "Hide".Re: Named Ranges Excel for Mac
The Paste Name option is available on the Insert > Name menu (not the ribbon). I don't remember seeing the "Use in Formula" ribbon button on Mac, but Paste Name is very similar. The other option is to just start typing the name where you want to use it in a formula and then choose it from the suggestion list that pops up. You can also press F3 on both Mac and Windows to bring up the Paste Name dialog. fernlopezRe: .xls files are opening at corner of the screen mac os
ramgo89 Are the XLS files being created by some other version of Excel or some other application/system? It seems that the window size and position information saved in the file is not correct, so it's important to identify how the files are getting into that state. Since the files open properly after adjusting the position of the window and then saving the file on your computer, the problem may be happening when the files are created/saved on another computer.Re: Mac/Excel
Kayla_Carter - I think you have a few options. 1. If you have an Office 365 subscription, you can go to Office.com and sign in. Then you can click the Install Office link and find some options for installing Office on your computer. 2. If your account doesn't include the desktop apps, then you can click on OneDrive, then upload the file from your boss. Once it's uploaded, you can open it in Excel for the web.Re: 2019 Excel on Mac no data entry form
null null I assume that you're trying to enter a bunch of records with minimal clicking and typing to navigate from one record to the next. I recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you're at the last field. If you're on the last record in the table, it will add a new record to the end of the list. In the screenshot below, the 2nd row was completed by typing e TAB f TAB g TAB h, and then the 3rd row was created by pressing TAB.
