difference between autofill and flash fill feature in excel
Answers
Answered by
1
Answer:
For example, you can use Flash Fill to separate first and last names from a single column or combine first and last names from two different columns. Autofill is a very useful Excel feature. It allows you to create entire columns or rows of data which are based on the values from other cells.
Answered by
13
❥ ᴀɴsᴡᴇʀ
❥ ғᴏʀ ᴇxᴀᴍᴘʟᴇ, ʏᴏᴜ ᴄᴀɴ ᴜsᴇ ғʟᴀsʜ ғɪʟʟ ᴛᴏ sᴇᴘᴀʀᴀᴛᴇ ғɪʀsᴛ ᴀɴᴅ ʟᴀsᴛ ɴᴀᴍᴇs ғʀᴏᴍ ᴀ sɪɴɢʟᴇ ᴄᴏʟᴜᴍɴ ᴏʀ ᴄᴏᴍʙɪɴᴇ ғɪʀsᴛ ᴀɴᴅ ʟᴀsᴛ ɴᴀᴍᴇs ғʀᴏᴍ ᴛᴡᴏ ᴅɪғғᴇʀᴇɴᴛ ᴄᴏʟᴜᴍɴs.ᴀᴜᴛᴏғɪʟʟ ɪs ᴀ ᴠᴇʀʏ ᴜsᴇғᴜʟ ᴇxᴄᴇʟ ғᴇᴀᴛᴜʀᴇ. ɪᴛ ᴀʟʟᴏᴡs ʏᴏᴜ ᴛᴏ ᴄʀᴇᴀᴛᴇ ᴇɴᴛɪʀᴇ ᴄᴏʟᴜᴍɴs ᴏʀ ʀᴏᴡs ᴏғ ᴅᴀᴛᴀ ᴡʜɪᴄʜ ᴀʀᴇ ʙᴀsᴇᴅ ᴏɴ ᴛʜᴇ ᴠᴀʟᴜᴇs ғʀᴏᴍ ᴏᴛʜᴇʀ ᴄᴇʟʟs.
Similar questions