heavy line between entries

[Dick7Access]

I want a heavy break line between entries in excel win 11. do not want color change every other color. Every thing I googled gives me everything except what I want.

 

[Isaac]

Alt+Enter works for me
No idea what you mean about colors.

 

[Dick7Access]

Alt+Enter works for me

Alt+Enter works for me
No idea what you mean about colors.

No idea what you mean about colors.

should have read dont want color changed every other line. reason I add that one qoogle recommend make every others line color change

 

[Dick7Access]

don't know what you mean by alt enter. Probable didn't explain myself properly. Once I make an entry and then click down for empty cell for a new entry I want the grid line between each entry to be heaver, as my entries are doubled lines. Just spent three days in ER for low sugar. VA wants a record of my sugar reading each day, and insulin intake

 

[The_Doc_Man]

Open the spreadsheet.
On the ribbon, choose Home.
In the ribbon area titled Font, look for a little box with dashed lines. It is to the right of the cluster of options for Bold, Italic, Underscore.
Now drag & highlight the area you want to change.
Click the down-arrow next to the little grid-box. You'll get a drop-down list of pre-defined effects.
At the bottom of that list is a "More Borders". Select "More Borders".
You will get a complex dialog box that allows you to pick the position, texture, and thickness of the cells in your selected area.
(NOTE: It will not work correctly if you have not previously selected the area you want to change.)
After making your selection, click OK.

 

[Dick7Access]

Open the spreadsheet.
On the ribbon, choose Home.
In the ribbon area titled Font, look for a little box with dashed lines. It is to the right of the cluster of options for Bold, Italic, Underscore.
Now drag & highlight the area you want to change.
Click the down-arrow next to the little grid-box. You'll get a drop-down list of pre-defined effects.
At the bottom of that list is a "More Borders". Select "More Borders".
You will get a complex dialog box that allows you to pick the position, texture, and thickness of the cells in your selected area.
(NOTE: It will not work correctly if you have not previously selected the area you want to change.)
After making your selection, click OK.

doc,
Three down arrows

First one top row format sin aliment no list with more boarders

Second under the ab the down arrow merge options, no more boarders

Third arrow bottom right of alignment, no more boarders

What am I missing

 

[Isaac]

Glad Doc seems to understand what you want, as I'm befuddled. It seems almost as if you want automatic Borders. (?)

 

[Dick7Access]

Glad Doc seems to understand what you want, as I'm befuddled. It seems almost as if you want automatic Borders. (?)

Yes I want the line between each even to be wider so it is easer to read where one medication ends and the next one starts. The more I google it i am coming to the idea it probably cant be done. I am probable imaging word and access capabilities. The first one I made I had all the fields spread all across the work sheet, but what I went to print it I realized some of the fields were printing on a second page. I may have to use access. I haven't been able to achieve what doc sent me yet,

 

[The_Doc_Man]

Forgot to ask: What version of Excel are you using? I might have a different one. The instructions I gave are Excel 2021.

 

[The_Doc_Man]

This is what it looks like for Excel 2021.

1. Open Excel, find the grid outline tool.

2. Highlight the range to be underlined. (If you don't, you won't underline anything because this tool needs a selected range to work.)

3. Click the grid-tool down-arrow. Note "More Borders" at the bottom of the list.

4. Click on "More Borders."

5. You will select the Style first, then click in the gaps to show where you want those lines to go.

6. After selecting the heavy lines and where you want them, click OK.

That's how you get the heavy lines. I suspect I should have included one more line in the original selection since in this case the bottom line of the selection isn't a heavy line, just a normal one.

 

[Gasman]

Alt+Enter works for me
No idea what you mean about colors.

Alt + Enter creates a new workbook for me?

 

[Dick7Access]

This is what it looks like for Excel 2021.

1. Open Excel, find the grid outline tool.
View attachment 120211
2. Highlight the range to be underlined. (If you don't, you won't underline anything because this tool needs a selected range to work.)
View attachment 120212
3. Click the grid-tool down-arrow. Note "More Borders" at the bottom of the list.
View attachment 120213

4. Click on "More Borders."
View attachment 120214

5. You will select the Style first, then click in the gaps to show where you want those lines to go.
View attachment 120217

6. After selecting the heavy lines and where you want them, click OK.
View attachment 120218

That's how you get the heavy lines. I suspect I should have included one more line in the original selection since in this case the bottom line of the selection isn't a heavy line, just a normal one.

latest office 365

 

[Gasman]

With a picture being worth a thousand words.

https://www.youtube.com/results?search_query=how+to+add+borders+to+cells+in+excel

 

[Pat Hartman]

VA wants a record of my sugar reading each day, and insulin intake

Hi Dick, I have a database I made originally for my husband 20 years ago and I've been adding to it ever since. It tracks lots of stuff. Give me a PM and we can chat later today if you like. I will add whatever you need and send it off to you. As you can see by the tabs it records lots of stuff and even produces a few reports that I bring to my doctors. It also handles multiple members of a household.

There are a couple of bugs I haven't gotten around to fixing though.

 

[Dick7Access]

Hi Dick, I have a database I made originally for my husband 20 years ago and I've been adding to it ever since. It tracks lots of stuff. Give me a PM and we can chat later today if you like. I will add whatever you need and send it off to you. As you can see by the tabs it records lots of stuff and even produces a few reports that I bring to my doctors. It also handles multiple members of a household.

There are a couple of bugs I haven't gotten around to fixing though.

View attachment 120223

yes I would appreciate it.

 

[Isaac]

Alt + Enter creates a new workbook for me?

Try doing it when you have already inserted your cursor into a cell.

This results in what he originally said he wanted which was a line break. It turns out he doesn't want a line break he wants borders

 

[Gasman]

Try doing it when you have already inserted your cursor into a cell.

This results in what he originally said he wanted which was a line break. It turns out he doesn't want a line break he wants borders

Ah, OK I see now.

 

[Pat Hartman]

Hi Dick,
I sent you a copy of the app this morning in a DM.
Pat

 

[Dick7Access]

Hi Dick,
I sent you a copy of the app this morning in a DM.
Pat

Thanks Pat none too soon. I have already downloaded it