Forum Discussion

Richard_James's avatar
Richard_James
Brass Contributor
Dec 10, 2019
Solved

Excel Question on a Mac

I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively. I want to know two things.

[1.] Is it possible to have a box for editing comments as I have outlined with dotted lines and shaded in blue, Instead of seral cells?

[2.] Is it possible to delete non-bolded names in rows C15-C24, and automatically have those cells move up, to look similar to i.e., F15-C24? Thank you. To say it another way, I am looking for a way to keep only bold text and compact in one list.

Thank you.
Richard

Excel on Mac
  • Rich99's avatar
    Rich99
    Dec 10, 2019

    Hi  Richard_James 

     

    I have attached your files with two solutions for the box  for adding comments. The filter for the bold is slightly more difficult. Excel has a sort option for cell colour but not for Bold font. It would need a macro writing to do that and I am not sure if you want to go down the route. See

    https://trumpexcel.com/filter-bold-font-formatting-in-excel/

    for possible solutions

     

    Richard

2 Replies

  • Rich99's avatar
    Rich99
    Iron Contributor
    Dec 10, 2019

    Hi  Richard_James 

     

    I have attached your files with two solutions for the box  for adding comments. The filter for the bold is slightly more difficult. Excel has a sort option for cell colour but not for Bold font. It would need a macro writing to do that and I am not sure if you want to go down the route. See

    https://trumpexcel.com/filter-bold-font-formatting-in-excel/

    for possible solutions

     

    Richard

Resources