When I protect a worksheet, some cells I don't want the user to be able to select at all, or edit in any way. And some cells I want to lock against the user editing, but still need him/her to be able to select those cells, whether it be for highlighting, copying, etc. Additionally, some cells I want the user to select and enter data, but not be able to edit the formatting of the cell. This is currently easy to attain. However, many of my cells have hidden formulas which I don't want the user to edit but I do want the user to be able to drag those cells down to apply the formula(s) to cells in subsequent rows. But currently, if the formulas in cells are hidden from the user being able to edit them, those formulas also cannot be applied to cells in subsequent rows when the user drags them. Likewise, in some of my financial spreadsheets, I have certain columns of cells with auto-calculations/formulas locked against user edit. When I need to select an entire row to drag and apply the formatting and formulas for each of its cells to the next row, I can't do it because Excel throws an error when attempting to drag a row containing one or more locked cells.
Excel needs 2 or 3 levels of protecting each cell in a worksheet where you can:
a. specify particular cells are locked against any form of user selecting or editing (complete lock down of those cells).
b. specify other particular cells in the same worksheet are locked against user edit, but can still be selected in order to copy their values, and their format/formula can also be dragged and applied to other cells.
c. specify particular cells are unlocked for editing while their formulas ARE locked against editing, but those formulas can still be passed and applied to other cells when dragged.
d. specify particular cells in the same worksheet are unlocked for editing while their formulas are locked against editing and those formulas cannot be passed or applied to other cells when dragged.
Excel has the potential to become one of the greatest, most versatile and useful apps on the planet - if Microsoft would just put in functionality its users actually need instead of continually adding bloat with useless features.
When I protect a worksheet, some cells I don't want the user to be able to select at all, or edit in any way. And some cells I want to lock against the user editing, but still need him/her to be able to select those cells, whether it be for highlighting, copying, etc. Additionally, some cells I want the user to select and enter data, but not be able to edit the formatting of the cell. This is currently easy to attain. However, many of my cells have hidden formulas which I don't want the user to edit but I…3 votes
This is a shortcut availible in excel in the US and it is very helpful. I would like it to be added to Danish excel.
Suppose you have a formula =Sheet2!A1+5 in A1 on Sheet1. If you press Ctrl + [ in Sheet1!A1, it will take you to Sheet2!A1.2 votes
Is it possible to get a transparent background so I can look through one or more Excel sheets while typing in the top / selected sheets in a group of sheets?
When I use Excel for planning for multiple teams, these are on their own tab.
I mark several tabs as a group, and here I would like to be able to browse through one or more of the sheets I have selected.
That way I can see / prevent collision and double booking between tasks in planning div. teams.
Thanks in advance
Greetings Roy1 vote
View multiple spreadsheet at the same time1 vote
how do I transfer my Microsoft account to another computer?1 vote
Allow a protected sheet to be copied to an unprotected sheet, or Template sheet within non-template workbook
Our business uses a LOT of excel reports, the vast majority of which we have one workbook per year and one worksheet per day, week, or month, where the standard procedure is to copy the sheet named 'Template' and rename it to the new date. However, almost every week at least one of the 'Template' sheets gets overwritten with data and the formulas or settings are lost, requiring me to replace the 'Template' sheet from a backup. If I protect the 'Template' sheet, when it's copied it is still protected so I'd have to give the password, negating the point of protecting it. What I'd like to be able to do is either include the option in the protection settings to allow it to be copied to an unprotected sheet, or to designate the sheet as a template so that when you hit the new sheet button it gives you the option to create it based on the sheet template.
We could use the .xltx however A, we'd have 12 or 52 or ~250 workbooks and wouldn't be able to use any multi-sheet calculations, and B, people would still ***** that up anyway such as copying the .xltx file and renaming it and then opening it and being forced to save it with a different incorrect name (which we already see anyway in areas where we did go with the .xltx route) or some other nonsense resulting in the deletion of the template. I've used up all my brownie points with the brass by beating users over the head for this stuff, so any assistance would be appreciated.
Our business uses a LOT of excel reports, the vast majority of which we have one workbook per year and one worksheet per day, week, or month, where the standard procedure is to copy the sheet named 'Template' and rename it to the new date. However, almost every week at least one of the 'Template' sheets gets overwritten with data and the formulas or settings are lost, requiring me to replace the 'Template' sheet from a backup. If I protect the 'Template' sheet, when it's copied it is still protected so I'd have to give the password, negating the point…1 vote
allow to make the background of a sheet / group of sheets transparent (except the tab)
This could be useful when using Excel for planning different scoolclasses ,timeschedules and activities over the semester due to conflict handling.
Especialt if it is possible to use within groups of sheets, and the active tab is the sheet where you write, and still can see the sheets below simultainously1 vote
As you are selecting a range of cells, the Name Box will display the dimensions of your selection in the format "1R x 2C". Please change the "x" to "×" (times sign), since this is the proper symbol.
We no longer live in the days when we need to worry about whether or not someone's computer has the correct fonts installed to be able to display non-ASCII characters. The "×" will display on modern computers.3 votes
I currently avoid using the Name Box because I can only get there by using the mouse. If there was a shortcut to get there it would be a really quick, direct way to name ranges and navigate to ranges.2 votes
Visually group and arrange worksheets on the home page. be able to color code them or upload images or icons to represent the worksheets. Users can click on the icon to get to the worksheet (makes it easier than scrolling left & right when you have a bunch of worksheets). Also makes it more visually appealing, professional. Could be done with VBA but would be nice out of the box.2 votes
Scrolling with large cells is usually a nightmare, when are Microsoft going to do something about this4 votes
Whenever a copy of a tab is created, in order to move it to the end, you need to scroll down the list of all the other tabs. The option "Move to end" should come at the beginning of the list!
What is the point of having it at the end, since you just scrolled down to the end already..
This is very frustrating when there are many tabs. Thanks!4 votes
window stacked screen
than excel do not show in right because group cell like as waste of screen view.1 vote
Worksheet tabs after latest update to W10, seem set in a larger font size. Changing font size seems no longer possible.
Need to be able to change font size of tabs to worksheets. Current sizing is set too large and intrusive,2 votes
I work with lots of lines and its tireing to try and track which row im on,
Please try and Highlight the active row.22 votes
SHOW ANSWERS TO all student EXCERSISES EXCEL 2016 workbooks/ ebooks1 vote
When you group columns and rows. The numbering of the groups takes away valuable screen space especially when working on laptops. Please create a thin row/column to display group numbers.1 vote
Create a Refreeze Panes option in the Freeze Panes drop down. This would remove the current Freeze Panes and apply a New Freeze Panes on the selected cell.3 votes
the dark mode in Excel should be like that of Outlook, meaning the entire thing should be darkened without huge swaths of space in white.
true dark mode. Current version hurts our eyes.3 votes
I have 40+ such icons on the Quick Access Toolbar for Excel & Word but with the October 2019 update, some of them have been relegated to an overflow toolbar because of the extra space between the icons. Please eliminate that extra space between the command icons in Quick Access Toolbar!!2 votes
- Don't see your idea?