Set Default to Copy and Paste Visible Cells Only
Hello, Does anyone know if we can set the Copy and Paste Function to default into copying and pasting only the visible cells? I'm using Excel 2016 in Windows 10. I've been doing the Alt + ; and then copying it way but when copying, I never want the hidden cells anyway. So I'm wondering if this could be set as default to avoid the extra step. Thanks!
Excel overlapping day of week and times
Hi there, Where I am currently working we have spreadsheets listing course lectures and seminars. As some courses/seminars cannot conflict with others, I need to find a way to identify which courses/seminars conflict. A sample spreadsheet is below. The day and time cannot conflict with another day/time that is the same or has overlapping times. I need a column at the end to identify all the exact and overlapping courses and seminars, not just by the times but by the day as well. I have been able to come up with a calculation to find overlapping times and another to find the same days/times however I am lost at how to create one calculation to do both. I am using Office 16. Subj Num DU CType Sec Days Time LING 1F25 1 LEC 1 M 1500-1700 LING 1F25 1 SEM 1 1 T 1600-1700 LING 1F25 1 SEM 2 1 W 1500-1600 LING 1F25 1 SEM 3 1 F 1600-1700 LING 1F25 1 SEM 4 1 F 1000-1100 LING 1F25 1 SEM 5 1 F 900 -1000 LING 1F25 1 SEM 6 1 W 1600-1700 LING 1F25 1 SEM 7 1 R 1400-1500 LING 5P01 3 LEC 1 R 1100-1400 LING 5P02 3 LEC 1 T 1100-1400 LING 5P03 2 LEC 1 T 1200-1500 LING 5P04 3 LEC 1 W 1100-1400 LING 5P05 2 LEC 1 M 1400-1700 LING 5P07 2 LEC 1 R 1400-1500 LING 5P08 3 LEC 1 M 1400-1700 LING 5P85 2 LEC 1 W 1100-1400 Any help would be greatly appreciated. Arlene 1070
Conditional Formatting - how to minimize formatting rule duplication with editing
Hi all, I built a spreadsheet for management to track project deliverables, and am running into two issues. I attached a slimmed down version of the spreadsheet for review. 1. The file contains several conditional formatting rules. When I turn it over for use, the end user has to insert rows in the table at times as new projects come in. I think this is causing the conditional formatting rules to explode. As a result, I have lots of rules that pertain to only one or a few cells, instead of the entire range as initially created. Is there a way to prevent this from happening? 2. The Projected columns contain rather complicated nested formulas for projecting due dates. I've asked the end user to NOT manually enter values into these columns, as it erases my formula, but with little luck. Is there a way to protect the integrity of these cells while allowing the end user to still add/remove rows from the table? Any guidance on these issues is greatly appreciated!! Thanks, CaseyDate Formatting
I wonder if anyone could help me please? Its probably really simple but I can't for the life of me get Excel to do as I would like. On all our company graphs/pivots etc, date is displayed as 18/06 (yy/mm) I have tried using a custom format but it always defaults to a full date 01/06/2018 in the display bar even though displaying correctly in the data It causes havoc for my pivots. How can I have the column format my dates as YY/MM to display in the data and in the display bar? Please? Thank you ClairImport Hyperlinked Text into a Data Validation Drop Down Menu
I am interested in creating a Data Validation drop down menu that contains report names (text) with an embedded hyperlink. The way I'm doing this now is creating a table on another sheet, listing all the reports (Report 1, Report 2, etc) within that table, and then embedding hyperlinks on all those report names. Then, on another sheet, I'm creating the drop down menu through Data Validation that sources those report names. Right now, the drop down menu appears, and I can choose the reports, but the embedded hyperlinks don't carry over. Is there a way to do this? I've found some answers online that suggest workarounds using HYPERLINK pointers, but this isn't what I want to do. Any help appreciated, thanks!
