Open the spreadsheet in your browser, and select Save to OneDrive.
#Highlighting in excel for mac how to
Here, we'll walk through how to use conditional formatting in Excel Online. Somehow (not too sure how this is related to the main sheet) main sheet works in the way I want it - active cell is always framed as normal.But what about when you're working in a spreadsheet? How can you highlight important or insightful sections of a large data set? How can you add visual flair to certain rows and columns that will not only make the spreadsheet more visually pleasing but also more useful? The problem was that the very hidden sheet protection did not enable to select unlocked cells (seems like even though the main sheet had it ticked the other one overruled it).Ĭonclusion: I have changed very hidden sheet protection and it is enabling selection of unlocked cells (because I don't want people to change anything there, I made all cells locked anyway). I have transferred everything to the new sheet and started from scratch. I was trying everything from activecell.active, to trying to get active cell value and set different background (so the user would know where is he typing), but it was still bothering me why is this happening.
cell B6 - B from the top and 6 from the side are grey, but the cell has no frame around it). You can still see where the cursor is because the row and column numbers are coloured in grey (i.e. I realised that the cell highlight (as in the thick green border) is disappearing each time I input data. On the main sheet only column B and E can be changed (rest is locked).
#Highlighting in excel for mac password
Both sheets are vba password protected and users can change only certain cells (only on the main sheet though, very hidden one is just to capture and save the changes that have been made in the main one - hope this makes sense). My spreadsheet has 2 sheets (one main one and one very hidden for certain users only). I was fighting whole morning with very similar issue to the one described, so hopefully I will be able to help. Thank you in advance for your communications. Any ideas, thoughts, or suggestions would be appreciated. This thread is the closest I've found to others that have had a similar issue. Have searched the internet for a resolution but have had no luck. When I bring the workbook onto my 2013 system I find no issues. The largest worksheet only contains approximately 150 row and makes use of 12 columns. The workbook contains 2 worksheets, 1 macro, and one pivot table. What's odd is if the user Alt/Tab's to a different window, then returns back to the workbook, the selected cells will display the proper borders until the active cell is changed. Nor do the unbordered columns remain the same throughout the day. I've not seen it duplicate the issue for the same set of columns. The first time they showed the issue to me it was not placing borders around columns D-G when they selected a row, then the next time it's a different set of columns. They are rebooting every night, but when they use the spreadsheet the following day the issue returns, but changes from day to day.
I have a customer which is using 2010 and having this issue on a daily basis.
0 kommentar(er)
