Please help! I will give thumbs up and review!! (Part 4 of 11) ...

90.2K

Verified Solution

Question

Finance

Please help! I will give thumbs up and review!! (Part 4 of 11)

image 10 Freeze Rows and or Columns at the Top or Left of Your Workbook so That Headings Stay in Place While You Scroll Down the Worksheet. How To: Place your cursor at the intersection of the rowscolumns you want fixed in place, i.e. Frozen then > View tab of the ribbon > Freeze Panes. Task Instructions: Freeze the first column so that it keeps the first column visible while scrolling through the rest of the worksheet. Do not freeze any rows. 11 Hide Worksheet Tabs How To: Pight click on the tab name > Select Hide Task Instructions: Hide the tab within this workbook that is called Sec 1-Hide Me. 12 Use Text to Columns to Separate a Column of Data Containing First Names and Last Names How To: Let's say you have First Names and Last Names separated by a space in a column. Select the cells > Data > Text to Columns > Delimited > Next > Choose Delimiter (space in this example) > Next > Select column data format and Destination > Finish. The warning will tell you there is already data here if the destination includes the cells that include the text. You can click Dk. Task Instructions: Use Text to Columns to separate the names listed below into the First Name and Last Name columins

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students