Forum Discussion
Similar cell autofill help
Can anyone tell by looking at this pic if there is any way of making the cells similar so autofill will save me time on the repeating information? The boxes are checked in the settings
7 Replies
I really don't know what you are looking for here but I do see that you have 'Merged' cells which will cause problems with many functionalities in Excel (avoid whenever possible). That said there is a great often unknown feature under cell format that does the same aesthetically without the actual merge. I recommend UNmerging ALL merged cells. Then highlight the cells you want to have centered across the columns and go to cell format and under alignment -> horizontal formatting scroll down to 'center across selection'
- I appreciate the reply. I tried that but it connects all 4 sets C-D/E-F/G-H/I-J into one cell centering Wheeling in between F and G.
I just want it to predict what I am trying to enter like my Checking register does(which has merged cells but they aren't separated up and down by unmerged cells.
As you see there are 3 loads in just 5 sections on that sheet that are almost Identical. That happens every day. At the end of the month there can be upwards of 2500 lines being used. If It could see I'm typing "Wheel" and notice I've previously used "Wheeling Nippon" and autofill/predictive text, It would save me tons of time.- You have to do that formatting for EACH section that is presently merged. So cells C3:D3 are merged with "SHIPPER NAME" so you highlight it and unmerge. Then, with C3:D3 highlighted you select format cell and tell it to center across selection. Repeat for all those others.
Or better yet completely change the format so you have a normal single line structure to your table. If you want or need this version for viewing or printing then create a reporting tab and pull the data from the master input table and format it this way for viewing/printing
