headings

I understand how to create a hyperlink to take me to other sheets using the hyperlink formula, but I become stuck with the next part. If I have headings in Row 1, I would like to be able to see which one was selected. For example, if we assume the columns are also the headings (heading A in...

I have a listbox and combobox using Excel 2016. The listbox and combobox show 5 columns and I can select a row and the last name is placed in a cell (using LinkedCell). 1. For some reason, the combobox does not show all the columns, as the listbox does, until I click on the down arrow. I can...

Am not sure if possible but I want to link to a page that has a series of options for descriptions and to display appropriate text. Ideally I would like a grouped text box of 8 headings with option buttons and if i clicked on anyone of them it would present the appropriate description. I'm...

I just got excel 2016 about 3 weeks ago and when I start a new sheet all the column and row headings are on the far right and not on the left plus when I open an existing excel workbook and need to add a new sheet everything moves to the far right with column and row headings. It all looks...

Hello, I'm having an issue with keeping columns and row headings visible, my excel document is longer than the page allows and I need help on how can I fix this.

I have a very large database in Excel 2016 and for the life of me I cannot get it to do what I used to be able to do in Excel 2003. I have it set up with the data Input under headings from A7 to R7 My Criteria headings are A1 to R1 and my Output headings are from V1 to AM1 I am using a Macro...

Hello all, How are you? Hope you're doing well. Need some help on a Vba that could copy down headings in columns BD to BL until last data cell in Column A. So to simplify things up I made simple headings which in reality are not that simple but are a bit unique.... From this To this...

Hi, Can I please pick your brains for some much needed excel help I am trying to set up data validation using dependent drop down lists, of which this is simple as long as you can define the names the same as the headings for each "dependent list" There is my issue, each of my headings may...

I created a clear all button on a sheet that needs to be cleared at the end of the year, ready for use at the start of the next year. The macro worked, but it also cleared out the table headings. (the names of each column) This was the macro I used: Sub ClearAllButFormulas() Dim wks As...

Hi all, I have a macro that saves to pdf and this works great, thanks to all your help Is there a way to insert page breaks depending on data in column D Column D has the headings for each selection of data beginning with "ZZ099...." Hope this makes sense Thanks

I have a CSV file that is exported from a program that we use, which is then pasted into a sheet in our excel workbook. The issue is the CSV may have different headings in different columns depending on who downloaded it. So when I pull the spreadsheet the heading "Hostname" is in column D but...

Could someone point me to a post that previously address this (can't locate) or assist me with the following: I'm trying to return the row header for the lowest value in the set. Using the table below what i'd like to display where the XX is would be "Changed" and "Dated". I'm struggling with...

Hello, I want to repeat spreadsheet headings at the top of every page. However, I am getting the "Print titles must be contiguous and complete rows or columns." I have tried the following: Page Layout - > Print Titles ->Sheet : Cell errors as : chose <blank> to no avail. Any suggestions...

I'm having problems getting the contents of a cell to display where there's text and numbers in the cell. It's a problem that I've never come across before, and I've no idea what the problem is. I have a table with column headings that I need to display in another table. Simply using =K4, L4...

Hi, I've found good answers to questions others have asked here in the past, so figured I why not try. I'm new to VBA and macros, I normally can do what I want with formulas but not this time. I currently have a button that asks for two separate text strings: A Name and A Type. What I want to...

Hello, Suddenly i found my excel column headings changed to figures instead of Alphabets and i need to know how to back to alphabets column headers. Example: instead of A B C D E F of column headers it became 1 2 3 4 5 6 and i need to get back to the alphabet column headings. Thanks

Hi, I need to customize the form options. I know how to add the form option to my ribbon. I know how to create all the table headings. My first two headings are Date and Time... I need the form to auto populate these fields and then the next two fields, I need them to keep the same info...

Hi All, I'm exporting data from an SQL database into Excel 2010. Part of the column headings disappears. When I select "wrap text" it won't wrap the text. The only way is to manually pull the column length down. Some headings are quite long so I do want to wrap the text. Can you help?! Many...

I'm interested in a macro that removes an entire row if the sentence in cell "O' doesn't end in a period. Also if the macro could ignore the first row which is headings. Thanks for your help, greatly appreciated.

Hello I’m having a problem with the date line in one of my reports. In my ‘Variables’ sheet, I have the following ranges and information. A B 1 CUR_YEAR_V 2017 2 CUR_MONTH_V 6 3 CUR_DAY_V 7 I have named the cells in B1:B3...