Apr 15 2019 09:24 AM - edited Apr 15 2019 09:25 AM
I see various templates which show a header section at the top of the sheet which in formatted independently from the lower rows. I would like to have a few cells in the "header" not tied to the formatting of the rows below. How is this done
Apr 15 2019 09:38 AM
Apr 15 2019 09:52 AM - edited Apr 15 2019 09:53 AM
For example, when I open Excel, I can choose a template. Several templates show a sheet header, with the rows and columns below. The first template I see is one for Sales Invoice Tracker. It has a section at the top which is formatted separately from the regular rows and columns below. See image below. I want this feature, where I can place cells independently from the formatting in the main row/column section.
Apr 15 2019 09:59 AM
Apr 15 2019 10:06 AM
I am sorry, but I don't see a Start tab in the ribbon or the Tools. Can you please clarify?
Apr 15 2019 10:14 AM
@wcstarks Apologies, it is the Home tab, in Dutch it is called Start.
Apr 15 2019 10:25 AM
Well, the Merge and Center feature is still associated with the formatting of the columns below. It does not allow formatting independent of the columns other rows and columns. It only allows one to merge two cells of the columns or rows. I cannot move them around or change their horizontal sizes without affecting all the associated columns below. So, there must be something else that is doing as shown in the image.
Apr 15 2019 10:38 AM
Never mind. As I look at the Invoice form, I can see that they have probably just merged columns.
Apr 15 2019 11:48 PM