default

Hi, I am using excel 2016. When I select "ctrl-c" to copy something, it no longer shows a highlighted border around the selection that was selected. Is there anyway to change this back to the default? This seems very strange. Thanks

Good morning. I have multiple workbooks in my Excel sheet. Is it possible for the default cell on each workbook to be cell E1 instead of A1? Thanks

Hi all, How would I modify the formula below so that if S16 is "0" then the default cell value is automatically 0? =IF(S16>0,(SUM(U16,X16,AA16,AD16,AG16,AJ16,AM16,AP16,AS16,AV16,AY16,BB16)/62),"") Thanks in advance

Hello. I have a user activated Userform with a ListBox in Excel 2016. The user clicks an activation button, which launches the form, the user chooses an entry from the listbox (its source list is a named ranged on another worksheet) and the macro assigns the chosen entry to a cell on the main...

Hi, I'm looking for a formula to do the following: Formula C22: Lookup Employee number VLookup - T_LOOKP,if match Lookup Age, if < 50 go to Admin and get maximium contributionamount else > 50 maximium. vlookupemployee find Traditional - calc methods and determine ifit is gross pay or...

How can I set a worksheet to have a printer independent default number of copies other than "1" in the print [preview] dialog? I have one worksheet in the workbook which people need to print 4 copies of, occasionally 3 or 5; highly unlikely to ever be one. I've tried suggestions I found on the...

Hi, I have excel files. There are different sections in this file. There are different features under each section. Unequal weights are available for these features. The sum of each section is 10. However, if there are no features under a section, the weight of the non-features needs to be...

Hi, Excel 2016 rolled out many new functions such as SWITCH, TEXTJOIN, etc. Unfortunately, these functions are not available for non-365 subscribers. I was wondering if somebody built a VBA UDF for SWITCH already? Its syntax is the following: Syntax SWITCH(expression, value1, result1...

hi, I have several different workbooks and worksheets within. I have some code that works fine on one workbook/sheet, but not on the others. this is because the worksheet name differs on the others...is there a default name i can put into the code that would work on all the worksheets? many...

I want a field in my table to default to the value of another field if the other field has a value. I cant find how to do this. Thanks

I am currently working with a large excel spreadsheet with multiple links to other documents. I have setup the linked documents to only update on prompt - as intended for this application. Whenever I open my master excel file and begin to make changes, the file will begin to require too much...

Hey everyone! Was wondering if someone could help me out with a mystery. I have a macro that asks the user to save their Excel. I was looking if I could default the Save As Text to be the text from say H16 on the Active Sheet. So instead of taking the default name of the workbook they have...

The Grid lines just not visible on a PC. following things I have tried. 1. The Gridlines are check-marked 2. I selected the whole sheet and gave "No fill" to Fill colour. 3. I went to Excel option, went into Advanced section, in Display section, the Gridline colour is black. After all these...

Hello all, I have a named range called band in column O in a sheet called Look and rows 2-38 I am using data validation drop lown list and enter =band as source when user clicks on drop down it defaults to row 38 and they constantly have to scroll up to the start is there a way that I can...

I use the formula to default to 70 if A11*B11 is less than 70. How do I change this so it doesn't default to 70 if the calculation is 0? Rich

When using Sort (and a couple other commands) a dialog box will pop up, the "Sort Warning", and ask you what you want to do? It then gives you 2 options "Expand the selection" and "Continue with the current selection" and by default it starts on expand the selection. So my question is whether or...

Hi, I have a task to create Excel sheet for team of people with questionable PC skills. For that reason I have created several foolproof safety nets using VBA, but they fail on one thing now. In order to make sure they work, I need make sure that people who use that file have macros enabled...

For example, I have the cells in Row 1, Columns A, B, C, and D as 1" by 1" . What I am looking for is to have the cells in Row 1, Columns A, B, C, and D bet set as 1" by 1 but the cells in Row 1 Columns G and H to remain the default Excel size. Can this be done?

I have a dropdown with vlookup in a sheet, I used Bill's clear and save , works great. Heres my situation, I want to have the cells with the dropdown go to the top of the list "Select" when I run his macro. Cant find this anywhere. That way when the workbook is open the areas that need to be...

I'm building a pivot table with quite a few columns. By default excel puts a column subtotal and doesn't repeat the row labels. I can remove the subtotals and make the labels repeat from the field menu. I wondered if there was somewhere no subtotals and repeat labels could be set as the default?