I cross out finished tasks in a spreadsheet list and going into Format Cells every time is slow. Word has a shortcut, does Excel?
Questions tagged #excel
i pay for microsoft 365 family and want to get properly good at excel, pivot tables and formulas mostly. does the subscription come with any official courses or is it all youtube?
I have a product list on one sheet and prices on another. VLOOKUP gives #N/A for about half the rows, but I can see the matching codes with my own eyes. Could it be spaces or number formatting?
I have a column of names in mixed case and need them uppercase. UPPER() works but puts the result in another column. Can it be done in place?
tried to find duplicates in excel and ended up back where i started. happy to be told i'm missing something obvious. is there an order to this?
i keep seeing macro in excel pop up and i've been ignoring it. the web version rather than the app, in case that matters. is it worth turning on?